I am trying to transfer data into a spreadsheet that is separated by a , (comma) that needs to go into separate columns. Does anyone have any ideas. Doing this manually will take me many hours. When I copy the data in to the spreadsheet it appears all in column "A". I need it separated into 5 different columns.
go to the data tab and select "convert text to columns"
select delimited and follow the wizard through
http://www.easyexcelanswers.com
On the ribbon on the data tab, there is an Icon, Text to columns. This will do exactly what you want.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Re: How to transfer data that is separated by a comma, into different columns
Thanks it worked Great and saved me a ton of time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks