Hi
If Cell A1 Contained 1,154,546,487,47,36,48,47,668 and so on. Using a Formula or Macro how can I get it to take each number(s) before each comma and put it in the next column on the same row?
So using the above example numbers you would end up with 1 in column A1 and 154 in column B2 and so on and so forth.
Thanks
Have you tried Text to Columns with comma delimiter?
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.
Hi,
=TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",41)),41*(COLUMNS($A:A)-1)+1,41))
Copy to the right as required.
Regards
Hi both
Thank you for your replies
sktneer- I have done the text to Columns with comma delimiter however I wanted a formula to do this if possible as I am constantly updating same spread sheet.
XOR LX - I used your formula but it only takes the 1st number before the comma and puts it in the next sell but does not do the same with the rest.
Thanks guys for your help
So I start with
Column A
12,23,3453
And end up with...
[table style="width:300px"]
[tr]
[td]Column A [/td]
[td]Column B [/td]
[td]Column C [/td]
[/t]
[tr]
[td]12[/td]
[td]23[/td]
[td]3453[/td]
[/tr]
[/table]
Last edited by Chantal4130; 05-02-2014 at 08:45 AM.
Try this code........
Please Login or Register to view this content.
Can you post a workbook with your attempt at applying my formula in?Originally Posted by Chantal4130
Regards
sorry XOR LX you were correct
I just needed to repeat across to the right as you stated.
My bad
Thank you for your help
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks