Is there a way that I can seperate a string of text within 1 cell to multiple cells?
i.e.
BRAND, PRODUCT, COLOUR, SIZE
is how the text appears in a column currently. Is there anything I can do to seperate the text into diffent cells at the point of the comma?
Please help!
Select Data
Data Menu
Text To Columns
Delimited
Tick Comma
Remove Tick from Tab
Next
Select/Change column formats as req
Finish
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks