General discussion

Locked

Import text to Excel

By johnnyjj ·
I am importing a text file with a with a user name that can have three fields. Sometimes there is a middle initial and sometimes there is not a middle initial or name. This variable causes the last three fields to shift back and forth. How do I get around this?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Import text to Excel

by DKlippert In reply to Import text to Excel

There's a very good discussion and solution for this problem on Chip Pearson's site:
http://www.cpearson.com/excel/FirstLast.htm
(There are no spaces in the URL)

Collapse -

Import text to Excel

by Shanghai Sam In reply to Import text to Excel

I am dealing with a text file has an identification number, first name, possible middle initial or name, last name, number field, date yyyy/mm/dd, and dollar amount. That is the setup for each record. Each field is separated by a space.

Collapse -

Import text to Excel

by mslizny In reply to Import text to Excel

If you do not have "empty" fields (two spaces?) for the missing middle initials you will not be able to have Excel provide a blank space for these names in the "middle initial" field.

For example, if you open the file in Word and replacing each space between the fields with a character, are there two characters when there is no middle initial? If your data does not account for the missing middle initials, you will have to add to the imported file, perhaps with Find and Replace in Word before you import it to Excel.

Collapse -

Import text to Excel

by Shanghai Sam In reply to Import text to Excel

That is pretty much what I was thinking also. Just wishing that someone would some trick to get around this. Thanks very much.

Collapse -

Import text to Excel

by johnnyjj In reply to Import text to Excel

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums