| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting text, like "Text to columns", but as a formula
I have first names and last names in one column that I want to split into two
columns. A formula woul be more practical than using the "Text to columns", as I'm constantly adding to the spreadsheet, and need to rapidly get the one column and two column versions out of it. I know LEFT and RIGHT work well for fixed length situations, so I'm hoping there's similar comand that uses a delimiter. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Being treated as Text | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
| How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
