| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Isolating words and numbers to a different column
Hi I have copied an adress list into a wpreadsheet, where both names,
mailadresses and phonenumbers are at one line. Is there a formula where I can isolate e.c. mailadresses to the next column automatically? I know left and right formulars, but is there something like that, but more like IF(the word conatins @) or something like that? And that goes for the numbers as well, so that all numbers goes to column C? Thanks -- Therese |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I sort a column numerically with both words and numbers i. | Excel Discussion (Misc queries) | |||
| auto sum column containing words and numbers | Excel Worksheet Functions | |||
| Isolating text and numbers | Excel Discussion (Misc queries) | |||
| looking to assign different numbers in column B to different words in column A | Excel Worksheet Functions | |||
| Searching for a words in a column from a list of words. | Excel Programming | |||
Threaded Mode
