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

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.

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

"sueshe" wrote:

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.

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

"Michael" wrote:

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

"sueshe" wrote:

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.

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.

On Mon, 10 Jan 2005 09:31:06 -0800, sueshe
wrote:

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.

Your welcome. Glad I could help.

"sueshe" wrote:

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

"Michael" wrote:

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

"sueshe" wrote:

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.