I have a cell which contains 5-digit numbers separated by commas which I need to extract and populate their own cell. As an example, say cell has the following data: 12345, 23456, 34567, 45678, 56789, 67890, etc. How can I get 12345 into cell A2, 23456 into cell A3, 34567 into cell A4, etc. Any ideas? Thanks in advance for your help.
If they aren't there already, insert blank columns (however many numbers you have) to the right of your data.
Do a Text to Columns>delimited>comma>Finish
Then copy B1,C1 etc. Select A2 and paste special > Transpose
Does that do what you want?
Do you have a whole column of these cells? or a whole row?
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
Hi,
Using Text to Columns you could parse A1 using the comma as the delimiter and then copy your new range (A1:F1) and Paste Special>Values+Transpose in A2.
HTH
Steve
Thanks for your help! That did it! It's been so long since I've used this functionality - I completely forgot about it. Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks