split cells that has data in it

elisa · Apr 30th, 2002, 08:29 AM

How do you split cell, which has multiple words, into different cells that contain individual word in the oringinal cell?
If there are serveral these cells in a column and each contain different number of words. I want to split all the words. Any function I can use in excel to do that? (I am dealing with a lot data here, simple copy and paste is too tidious.) thank you.

AJ · Apr 30th, 2002, 08:34 AM

Had a bit of mucking about of this ilk myself recently where I wanted to do it with formulae http://www.mrexcel.com/board/viewtop...c=6289&forum=2
Never really managed to resolve it though.

However, in your case if your not as fussy as I am, you could just use Data>Text to Columns with a Space as the delimiter.

If you have variable amounts of spaces in between your words, and/or extra spaces at the beginning or end of the cell, rather than re-invent the wheel, just download asap-utilities from the website of the same name and use it's "Delete leading, trailing and excessive spaces" feature.

HTH
AJ

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 08:29 AM	#1
elisa New Member Join Date: Apr 2002 Posts: 7	How do you split cell, which has multiple words, into different cells that contain individual word in the oringinal cell? If there are serveral these cells in a column and each contain different number of words. I want to split all the words. Any function I can use in excel to do that? (I am dealing with a lot data here, simple copy and paste is too tidious.) thank you.

Apr 30th, 2002, 08:34 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Had a bit of mucking about of this ilk myself recently where I wanted to do it with formulae http://www.mrexcel.com/board/viewtop...c=6289&forum=2 Never really managed to resolve it though. However, in your case if your not as fussy as I am, you could just use Data>Text to Columns with a Space as the delimiter. If you have variable amounts of spaces in between your words, and/or extra spaces at the beginning or end of the cell, rather than re-invent the wheel, just download asap-utilities from the website of the same name and use it's "Delete leading, trailing and excessive spaces" feature. HTH AJ