LinkBack URL
About LinkBacks
I have a cell which contains multiple values such as
A
230, 200, 180, 170
and I need to take each value and put them into separate cells such as
A B C D
230 200 180 170
Is this possible to do, and if so, what would the command/macro be?
Thank you
I have a cell which contains multiple values such as
A
230, 200, 180, 170
and I need to take each value and put them into separate cells such as
A B C D
230 200 180 170
Is this possible to do, and if so, what would the command/macro be?
Thank you
Try Text to Columns under the Data tab
Click on star (*) below if this helps
hi engineerlady, welcome to the forum. you don't have to do it with VBA. select column A & go to Data -> Text to Columns -> Delimited -> Next -> check "Space" & "Comma" -> Finish
that will separate the data by commas & spaces. if you need VBA, here's a recorded version:
Please Login or Register to view this content.
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
All you have to do is go to the DATA tab on excell, select TEXT TO COLUMNS and when the popup wizard comes up, select DELIMITED and then check the box marked next to the word COMMA. Then click FINISH. That will do it for you real quick. It works with any type of data, words or numbers or a combination of words and numbers.
Thanks for your time and help!
Jane
Wow, thank you so much!!! Very much appreciated!
Hi engineerlady,
if you already have all data in one column, you can try with this user defined function:
You can find example of using it in attachment...Please Login or Register to view this content.
Regards,
If a post helps press star sign 4 my reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks