Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split data in one cell like ALT-Enter
If somebody can help me out :)
I have a sheet with several rows. In column D a lot of text is included with separator slash. I need a macro that produce the following action on it in all cells in column D Example Cell D2 exist: aaaaa/bbbbb/ccccc/ddddd Should be changed to aaaaa bbbbb cccccc ddddd All text stays in the same cell. The macro has to do ALT-Enter on each slash and delete the slash character. Then next row till last. Regards, Johan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split data in one cell like ALT-Enter
Hi Joan,
Sub test() With Range("D:D") .Replace What:="/", Replacement:=Chr(10), LookAt:=xlPart .WrapText = True End With End Sub isabelle Le 2017-01-18 Ã* 16:48, a écrit : If somebody can help me out :) I have a sheet with several rows. In column D a lot of text is included with separator slash. I need a macro that produce the following action on it in all cells in column D Example Cell D2 exist: aaaaa/bbbbb/ccccc/ddddd Should be changed to aaaaa bbbbb cccccc ddddd All text stays in the same cell. The macro has to do ALT-Enter on each slash and delete the slash character. Then next row till last. Regards, Johan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split data in one cell like ALT-Enter
THANKS !!!
Works as requested :) Regards, Johan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split data in one cell like ALT-Enter
Glad to help. Thanks for the feedback.
isabelle Le 2017-01-21 Ã* 00:10, a écrit : THANKS !!! Works as requested :) Regards, Johan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup if #N/A then enter enter data in cell I4 | Excel Discussion (Misc queries) | |||
Enter data and press enter to move to specific cell | Excel Programming | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
Auto enter data from cell above on enter | Excel Programming | |||
split cells with Alt+Enter | Excel Worksheet Functions |