I have an excel file with 400 records.
The records in this format :-
" name, email, 1,1 "
One record occupies 1 cell.
Now I want to create one column for name and for email and for 1 and 1.
How can I do that?
dhruv_arora
5
Junior Poster
BLuv
0
Newbie Poster
when you import the file to excel, (I assume its a rich text format or txt) it will automatically separate each record, recording each comma like a break in cells. alls you need to do is go to the text file, and at the top of all the records, type this:
name, email, 1,1
it will put the column headings just the same way.
hopefully this helps =)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.