text in new cells
 

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--

text in new cells
 

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



"Harrison" wrote in message
...
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--

text in new cells
 

Select your data
Goto the menu DataText to Columns
DelimitedNextCommaFinish

Biff

"Harrison" wrote in message
...
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--

text in new cells
 

thank you so much....this really helped...have a great day!
--
Harrison


"R1C1" wrote:

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



"Harrison" wrote in message
...
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--

text in new cells
 

Even better.

Regards,

Alan


"T. Valko" wrote in message
...
Select your data
Goto the menu DataText to Columns
DelimitedNextCommaFinish

Biff

"Harrison" wrote in message
...
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--