when importing .txt files can I separate the data horizontally Chrisinct 06.07.2006 18:45:02 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.

Re: when importing .txt files can I separate the data horizontally Gord Dibben <gorddibbATshawDOTca> 06.07.2006 18:55:09 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 On Thu, 6 Jul 2006 11:45:02 -0700, Chrisinct <Chrisinct[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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.

Re: when importing .txt files can I separate the data horizontally Chrisinct 06.07.2006 19:13:01 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" wrote: [Quoted Text] > 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 > > On Thu, 6 Jul 2006 11:45:02 -0700, Chrisinct > <Chrisinct[ at ]discussions.microsoft.com> wrote: > > >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. > >

Re: when importing .txt files can I separate the data horizontally Gord Dibben <gorddibbATshawDOTca> 06.07.2006 19:19:15 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 On Thu, 6 Jul 2006 12:13:01 -0700, Chrisinct <Chrisinct[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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" wrote: > >> 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 >> >> On Thu, 6 Jul 2006 11:45:02 -0700, Chrisinct >> <Chrisinct[ at ]discussions.microsoft.com> wrote: >> >> >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 MS Excel MVP

Re: when importing .txt files can I separate the data horizontally Chrisinct 06.07.2006 19:36:02 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. [Quoted Text] > 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 > > > On Thu, 6 Jul 2006 12:13:01 -0700, Chrisinct > <Chrisinct[ at ]discussions.microsoft.com> wrote: > > >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" wrote: > > > >> 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 > >> > >> On Thu, 6 Jul 2006 11:45:02 -0700, Chrisinct > >> <Chrisinct[ at ]discussions.microsoft.com> wrote: > >> > >> >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 MS Excel MVP >

Re: when importing .txt files can I separate the data horizontally SteveW <sj_walton[ at ]nothotmail.com> 07.07.2006 18:12:57 On Thu, 06 Jul 2006 20:36:02 +0100, Chrisinct = <Chrisinct[ at ]discussions.microsoft.com> wrote: [Quoted Text] > 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 litt= le = > and > space is too much. > > I want to import it in this fashion- [brackets show what I need per ce= ll] > > [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 Count= ry 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 >> >> >> On Thu, 6 Jul 2006 12:13:01 -0700, Chrisinct >> <Chrisinct[ at ]discussions.microsoft.com> wrote: >> >> >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" wrote: >> > >> >> 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 >> >> >> >> On Thu, 6 Jul 2006 11:45:02 -0700, Chrisinct >> >> <Chrisinct[ at ]discussions.microsoft.com> wrote: >> >> >> >> >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 th= en >> >> >manipulate it? I appreciate the help. >> >> >> >> >> >> 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. -- = Steve (3)