| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find text within text
I have a list of names, each separated by a semi-colon and a space, which I
have pasted into a cell (eg G1 = First Last1; First Last2; First Last3; First Last4; First Last5) How do I split out the names into a column so that A1 = First Last1 A2 = First Last2 A3 = First Last3? I've used combinations of Find, Mid, Len but I just can't nail the result. Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
| Find text within text | Excel Discussion (Misc queries) | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
Threaded Mode
