Reformatting a large database

J

Jamey

Hello!

I have a large spreadsheet of Contacts with standard address/phone/email
listings. I did not create this sheet, and the alignment is all spread out. I
need to format it in a uniform way so that I can import it (and map it
properly) into ACT after converting it to a .csv format. Short of copying and
pasting thousands of fields into a new spreadsheet, is there any way I can
clean up this one so it will work? I need to get rid of all the empty lines
and spaces, and have all fields line up accordingly.
Looking at the spreadsheet in its current format, everything looks lined up,
but once coverted into a .csv format, it's a big mess.

Please help!
 
Top