| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting out a wrapped text entry
Hello,
I have a column of over 600 addresses, and they are entered as follows: 1 Luke Road Luke Town Luke City Lukeshire LU1 1KE When unwrapped, it obviously just looks like one long sentence with squares where the (ALT+Enter)'s were. My issue is that I would like to split each line of the address out into adjacent columns. Any help would be gratefully received, and save me a few hours of manually typing in commas so that I can TTC it! -- Thanks Luke |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing wrapped text | Excel Discussion (Misc queries) | |||
| Wrapped text is not visible, how do I fix this? | Excel Worksheet Functions | |||
| Wrapped text | Excel Discussion (Misc queries) | |||
| Limit to Wrapped Text? | Excel Discussion (Misc queries) | |||
| wrapped text does not display | Excel Discussion (Misc queries) | |||
Threaded Mode
