I have a Comma Delimited FIle that requires 10 characters for name

[Guest]

I use Excel a lot, but am by no means fluent with it. I'm trying to create a
..csv file, I have columns set up with (thousands) names, and those cells have
to have 10 characters regardless of actual name length. Is there a way to do
that without me having to space after each name? Also, is there a way to
split a full name (ex. LASTNAME,FIRSTNAME,MI) into three seperate columns?
They are seperated by a space, but all are contianed in the first column.

 

[Guest]

If you using Excel 2003, try Data-Text to columns

 

[Guest]

Thanks so much, that worked!!! That will save me so much time!!!!!

 

[Myrna Larson]

You probably need to use formulas to get the data into the format you want.
First use Data/Text to columns to split the name. Choose Delimited, but select
the right delimiter (you say it's a space, but your example uses a comma).

After you've done that, you can use helper columns with a formula like

=LEFT(A1&" ",10)

to add trailing spaces to a length of 10.

Then you'll have to convert the formulas to their values (look at Help for
Paste Special/Values), delete the original data, and write your CSV file.

 

[Guest]

Your welcome. Glad I could help.

Thanks so much, that worked!!! That will save me so much time!!!!!