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