Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup text then copy over to new cell
I have a spreadsheet setup and in one cell there are address details but in
between the address details there is a square symbol. In some of the cells there are up to 6 different address lines with some only have 1 or 2 address lines in there. What I would like it to do is take the text from Initially before the first symbol and bring that text into an address line 1 cell and then from after that take the text from just after the symbol to the next symbol and bring that text through into the next possible cell. Hope this makes sense. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy a number into a text cell, keeping leading zeros? | Charts and Charting in Excel | |||
Lookup certain text within a cell, PLEASE HELP! | Excel Worksheet Functions | |||
lookup a text cell and return text | Excel Discussion (Misc queries) | |||
copy a formatted cell to another sheet as text without format | Excel Discussion (Misc queries) | |||
Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) |