when importing .txt files can I separate the data horizontally

[Guest]

I have to import a .txt file from a database query into an excel spreadsheet
and I can't get the data to format properly. It comes in this format from
the query...

1111 PHYSICIAN OFFICE RP 111 WEST ST 880
555-1212


SMALLVILLE, CT 06001 880
555-1212

Can I import that data into excel in a cell by cell format and then
manipulate it? I appreciate the help.

 

[Gord Dibben]

Your example data is all broken up so's hard to get a read on how it looks.

Does it come in as one column and one row or how?

Describe or re-format your post to readable.


Gord Dibben MS Excel MVP

 

[Guest]

sorry it looked better when I first posted it.
Seperated out - First line contains this info (quotes added for ease of
recognition)

"1009 PHYSICIAN OFFICE RP 240 EAST ST 860 747-4541"

second Line contains this Info

"PLAINVILLE, CT 06062 860 793-1281"

 

[Gord Dibben]

So row one contains the data in 4 cells or one cell and in which column(s)?

Row 2 contains the data in 2 cells or one cell and in which column(s)?

What do you want to do with the data from the two rows?

Place all one one row in separate cells or all in one cell?

"Manipulate" is quite a vague description.


Gord

sorry it looked better when I first posted it.
Seperated out - First line contains this info (quotes added for ease of
recognition)

"1009 PHYSICIAN OFFICE RP 240 EAST ST 860 747-4541"

second Line contains this Info

"PLAINVILLE, CT 06062 860 793-1281"

Gord Dibben MS Excel MVP

 

[Guest]

I want to be able to choose what data goes in a specific cell. I can't
manage this by using a delimiter because a comma and tab does too little and
space is too much.

I want to import it in this fashion- [brackets show what I need per cell]

[1009] [PHYSICIAN OFFICE] [RP] [230 WEST ST]
[860 757-4111]


[PLAINVILLE], [CT] [06000]
[860 711-1222]

If I can just get that specific info into individual cells then I can move
it to where I need to to go specifically this format...

EntryCode Name Mnemonic Address Address City State Zip Phone Fax Country County Inactive? Create?

wrapped by formatting but this is the top row of the spreadsheet

Thanks for your patience.

 

[SteveW]

I want to be able to choose what data goes in a specific cell. I can't
manage this by using a delimiter because a comma and tab does too little
and
space is too much.

I want to import it in this fashion- [brackets show what I need per cell]

[1009] [PHYSICIAN OFFICE] [RP] [230 WEST ST]
[860 757-4111]
[PLAINVILLE], [CT] [06000]
[860 711-1222]

If I can just get that specific info into individual cells then I can
move
it to where I need to to go specifically this format...

EntryCode Name Mnemonic Address Address City State Zip Phone Fax Country County Inactive? Create?

wrapped by formatting but this is the top row of the spreadsheet

Thanks for your patience.

So row one contains the data in 4 cells or one cell and in which
column(s)?

Row 2 contains the data in 2 cells or one cell and in which column(s)?

What do you want to do with the data from the two rows?

Place all one one row in separate cells or all in one cell?

"Manipulate" is quite a vague description.


Gord




Gord Dibben MS Excel MVP

it gets all messy when you have 2 lines which will have different
conversion rules.
Initially add a couple of columns A 1,1,2,2,3,3 ... and B with 1,2,1,2,1,2
....

Now sort all the data on B - deal with the two different formats
Then you can sort back via sort on A,B to get the original data list.

as for the conversion... first change multiple spaces to a unique
character say "!"
Then you can seperate fields on that character.
Space won't work as you have that in the data.