| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function on "Text to Columns"
I have list of Names for e.g.
Antony, John - 30022275 David, Joan - 30022277 When I used "Text to Columns" function I am able to saparate Names in different cells but unable to saparate "Joan - 30022277" I tried even removing " - " but did not worked, is their any function so that I can saparate all for e.g. A1 - Antony B1 - John C1 - 30022275 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| disabling default "text to columns" while *.csv file opening | Setting up and Configuration of Excel | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Excel should support a proper inverse to "Text to columns" | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Threaded Mode
