Hi,
I need to separate a lot of values in on cell. I guess the best way to do it is through the text to column function. But I want the first word in the cell to remain in the first column and the rest in the 2nd column. Right now I able just to put one word in one column which results in 6 columns.
Is it possible to make it into two columns with the first word in the original column and the all the other words in the 2nd column?
Thanks.
Assuming you have entered the values in cell A1 and the words are separated by space, then
Please Login or Register to view this content.Is this what you want?Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Or a slightly shorter method...
=LEFT(A1,FIND(" ",A1,1)-1)
and then
=SUBSTITUTE(A1,A2&" ","")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
If you really want to use Text to Columns,
First do a search and replace, find [spacebar], replace with [spacebar, spacebar, spacebar, ....]
Now you can do a fixed width between the first and second words. Remove any other column breaks.
Then reverse your search and replace to remove the extra spaces.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks