Home |
Search |
Today's Posts |
#1
|
|||
|
|||
place text seperated by a space in a column into seperate columns
I need to place text seperated by a space in one column into two seperate
columns. |
#2
|
|||
|
|||
"hobiedog" wrote in message
... I need to place text seperated by a space in one column into two seperate columns. This is my "quick and dirty" solution (at 32C/90F in my office today it's simply too hot to develop any formula :-): - isolate the column containing the 2 text elements (copy it into a new workbook) - save as text file (tab delimited) - open text file, choose delimited and space as delimiter - copy back the resulting 2 columns into your original workbook I'm sure one of the gurus will come up with an elegant formula. The choice is yours! |
#3
|
|||
|
|||
Hi
I reckon Data|Text To Columns should do the trick for you. -- Andy. "hobiedog" wrote in message ... I need to place text seperated by a space in one column into two seperate columns. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Search a Column by text length | Excel Worksheet Functions | |||
another text to column problem | Excel Worksheet Functions | |||
How can I make Excel return the text in column A only if there is. | Excel Worksheet Functions |