text in new cells

H

Harrison

hi all...

i have a bunch of data that was given to me all run together, but is
seperated by commas, for example:

642, 758, 25895, 245, 755, 4444, and so on

i am wondering if there is any way to take all this data and put each piece
in a seperate cell, the only way i have thought of is to copy and paste each
data entry, but when you get up to at least 200 sets of data, that becomes
impractical. any help would be greatly appreciated. thanks for your time

--Harrison--
 
R

R1C1

What file format is your "bunch of data" in? If it is in Excel, and on one
sheet, an easy method is to copy the data, paste it into Notepad, save it as
"All Files", and give it a .csv extension to make it a comma delimited file.
Open the file in Excel. Excel will automatically separate your data.

If your "bunch of data" is not in Excel, you can still use the same method
to achieve the same results.

If you are needing a VBA solution, you need to post more information about
the "200 sets of data" and what file type the data is stored in.

Regards,

Alan
 
T

T. Valko

Select your data
Goto the menu Data>Text to Columns
Delimited>Next>Comma>Finish

Biff
 
Top