| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to split address blocks across multiple cells
I have cells of block addresses that are delimited (tab I believe - there's a
small square that appears). I need to split the addresses out into separate columns for each line of address. I tried using the Text to Columns wizard as suggested by Excel Help, but ended up with only the first line of address being posted in the cell to the right (the rest of the address was nowhere to be seen). I'm sure I've done this before but can't for the life of me remember how I did it... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Enable a new dimention: sub-level of split cells | Excel Discussion (Misc queries) | |||
| How do I insert a symbol BEFORE text for multiple cells in Excel? | Excel Worksheet Functions | |||
| using multiple split cell references in linest | Excel Worksheet Functions | |||
| how do i add the same text after current text in multiple cells | Excel Discussion (Misc queries) | |||
Threaded Mode
