Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to separate words between blanks
I have a database where the names contain several words (names). I want to
break them up so that there is a word (name) in each column. For example, if the entry is "A B C", I want to make three columns with "A" in one, "B" in the second, and "C" in the third. Anyone have any ideas? |
#2
|
|||
|
|||
There's a simplest way to this query...
type the sentence in a cell.. eg: "Hello how are you" then cut (CTRL+X) words "how are you" And paste it in a different cell The words are automatically split into seperate columns If it works please vote for this answer.. "Mexage" wrote: Try the "Text to Columns" function under the Data menu. Then select delimited and after clicking on OK select the Space option to split at each space. Hope that helps, and if it does please vote for this answer G.Morales "Elizabeth" wrote: I have a database where the names contain several words (names). I want to break them up so that there is a word (name) in each column. For example, if the entry is "A B C", I want to make three columns with "A" in one, "B" in the second, and "C" in the third. Anyone have any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
how to separate words between blanks | Excel Discussion (Misc queries) | |||
Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
Separate last word in cell with more than 2 words? | Excel Worksheet Functions | |||
linking files with blanks | Excel Discussion (Misc queries) |