LinkBack URL
About LinkBacks
Hi, I need the formula to separate the numbers with commas in a cellto other columns as shown in sample.
This data comes from internet and automatically updating certain intervals, so the text to columns option has no use
Pls help
Hi, I need the formula to separate the numbers with commas to other columns as shows below
Hi, I need the formula to separate the numbers with commas in a cell
This data comes from internet and automatically updating certain intervals, so the text to columns option has no use
Pls help
welcome to the forum, binoos. try this in B13:
=--TRIM(MID(SUBSTITUTE($A13,",",REPT(" ",100)),1+(COLUMNS($B13:B13)-1)*100,100))
copy down & across. a Merry Christmas in advance!
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
You have done, dear benishiryo.... Hats off. Thank you
Merry Christmas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks