Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting cell contents
A cell contains multiple phrases and sentences for a total of 255
characters. (Each phrase is separated by a semicolon; each sentence is separated by a comma). Other than using "Wrap Text", how can I make each phrase or sentence start at the left edge of the cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting cell contents
Hi Gary,
Can use find and replace and replace with the character which is inserted when you use Alt/enter to start a new line in a wrapped text cell. Backup your data first. Select the data to be modified. In Replace dialog box, insert a comma in Find what (Might need comma plus a space if you have a space after the comma otherwise you will have a leading space on the next line.) In Replace with, hold the Alt key and press Enter. (You won't see anything) and then Replace all. Repeat for semi colon. If you want to retain the comma/semicolon, then simply include it in the replace with. Regards, OssieMac "GARY" wrote: A cell contains multiple phrases and sentences for a total of 255 characters. (Each phrase is separated by a semicolon; each sentence is separated by a comma). Other than using "Wrap Text", how can I make each phrase or sentence start at the left edge of the cell? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting cell contents
I think you meant Alt + 0010 on numpad or CTRL + j
Gord Dibben MS Excel MVP On Mon, 5 Nov 2007 14:04:01 -0800, OssieMac wrote: In Replace with, hold the Alt key and press Enter. (You won't see anything) and then Replace all. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting cell contents
You're right Gord. Thanks.
Regards, OssieMac "Gord Dibben" wrote: I think you meant Alt + 0010 on numpad or CTRL + j Gord Dibben MS Excel MVP On Mon, 5 Nov 2007 14:04:01 -0800, OssieMac wrote: In Replace with, hold the Alt key and press Enter. (You won't see anything) and then Replace all. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting cell contents | Excel Discussion (Misc queries) | |||
Trouble splitting cell contents | Excel Discussion (Misc queries) | |||
Splitting the contents of a cell | Excel Discussion (Misc queries) | |||
Splitting the contents of a cell? | Excel Worksheet Functions | |||
Splitting Cell Contents with a comma | Excel Worksheet Functions |