Need A Macro that Will Remove Comas and place Data in multiple Cells

foible81

New Member
Joined
Dec 11, 2010
Messages
1
I have a sheet of data with large amounts of information contained in just one cell. All of the numbers are separated by comas though, and I hoped to see if anyone could help me organize the data. I'm relativly new to Macros, so I was drawing a blank on what I should do.

thanks.
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,651
Try selecting the data, Data > Text to Columns, specify Delimited with comma as the delimiter. Click Finish.
 

Forum statistics

Threads
1,085,495
Messages
5,384,004
Members
401,871
Latest member
allemandi

Some videos you may like

This Week's Hot Topics

Top