Link to home
Start Free TrialLog in
Avatar of blossompark
blossomparkFlag for Ireland

asked on

copying comma seperated data into excel worksheet

Hi,
I have a list of comma separated column names in a text file that I want to load into the first row of an xlsx worksheet, how do I do it?
i have tried pasting but all ends up in the first cell, I want each value to occupy sequential cells.
thanks
ASKER CERTIFIED SOLUTION
Avatar of Mrugesh1
Mrugesh1
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jppinto
jppinto
Flag of Portugal image
If you have the data pasted into an Excel sheet, into the first column, you can also use the Data-Text to Columns option to split the data into their respective columns.

jppinto
Capture.JPG
Avatar of blossompark
blossompark
Flag of Ireland image

ASKER

Hi Mrugesh1, thanks for that, worked perfectly...
Hi jppinto, thanks for your comment, job completed by the time i saw yours...but very useful for future ref...thanks