LinkBack URL
About LinkBacks
I have used concatenate to create this :
R 01 001 A 1 R01001A1 R 01 001 A 2 R01001A2
I want to do the same thing in reverse:
taking R01001A1 and seperate into the original 5 cells but on another sheet
Thanks
I have used concatenate to create this :
R 01 001 A 1 R01001A1 R 01 001 A 2 R01001A2
I want to do the same thing in reverse:
taking R01001A1 and seperate into the original 5 cells but on another sheet
Thanks
Copy the text strings into column A of the second sheet.
Now use Data > Text To Columns > Fixed Width to split them out. Set the break points on page 2 of the wizard.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi norm01
Find the attached with the formula. If your example is in A1 then put the formula below in B1 and pull to the right.
DonkeyOte showed me this a few months ago. What it does is takes every space in your string and substitutes it with lots of spaces. Then it takes the a mid from the string that is blown up with spaces and uses Trim to arrive at what you want.
Please Login or Register to view this content.
hope this helps.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks