Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I move data to a new line in a cell after a comma?
I am trying to move data from one line in a cell to 2 lines in a cell. To
move all the data after a "comma" Vis: From 12 Beach St, Palm Beach Qld 4111 To 12 Beach St, Palm Beach Qld 4111 Can anyone suggest a formula ? Thanking you in advance Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I make more then one line of pasted text not move to one cell? | New Users to Excel | |||
Can you use enter to move to the next line within a cell | Excel Discussion (Misc queries) | |||
Exctracting comma seperated data from a single cell | Excel Discussion (Misc queries) | |||
How to seperate data in a cell which is split by a comma | Excel Worksheet Functions | |||
how do I get data from an array into one cell (comma delimited) | Excel Discussion (Misc queries) |