Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing from a *.txt file
I am trying to import a *.txt file that has a semi-colon delimiter. When I
run the import, Excel places each individual record into a new column. I need to import each record into a new row instead. Can you help? Randy Bratton |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing from a *.txt file
Is the semicolon a delimiter between fields on that single row/record/line?
Or is the semicolon followed by a newline character--so that each row/record/line only has one field? Randy Bratton wrote: I am trying to import a *.txt file that has a semi-colon delimiter. When I run the import, Excel places each individual record into a new column. I need to import each record into a new row instead. Can you help? Randy Bratton -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing from a *.txt file
yes- these are email addresses so for example the text file shows
; ; etc. When I import into Excel, shows up in cell A1, shows up in cell B1, etc. all the way across Row 1. I really need for the data to import as A1, A2, etc. Thanks. -- Randy Bratton "Dave Peterson" wrote: Is the semicolon a delimiter between fields on that single row/record/line? Or is the semicolon followed by a newline character--so that each row/record/line only has one field? Randy Bratton wrote: I am trying to import a *.txt file that has a semi-colon delimiter. When I run the import, Excel places each individual record into a new column. I need to import each record into a new row instead. Can you help? Randy Bratton -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing from a *.txt file
Just to add to David's response.
Open you text file in MSWord. Select all the text Edit|replace what: ; (semicolon character) Click on the More button if the additional options aren't visible Click inside the Replace with box click the Special characters button select paragraph mark Replace all Copy|paste special|text into Excel or save as a .txt file and import the way you like. David Biddulph wrote: Edit your txt file, and replace all semi-colons by paragraph markers. Alternatively, having pulled everything into a row in Excel you can Copy, then Edit/ Paste Special/ Transpose to put into a column. -- David Biddulph "Randy Bratton" wrote in message ... yes- these are email addresses so for example the text file shows ; ; etc. When I import into Excel, shows up in cell A1, shows up in cell B1, etc. all the way across Row 1. I really need for the data to import as A1, A2, etc. Thanks. -- Randy Bratton "Dave Peterson" wrote: Is the semicolon a delimiter between fields on that single row/record/line? Or is the semicolon followed by a newline character--so that each row/record/line only has one field? Randy Bratton wrote: I am trying to import a *.txt file that has a semi-colon delimiter. When I run the import, Excel places each individual record into a new column. I need to import each record into a new row instead. Can you help? Randy Bratton -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing TXT file from web | Links and Linking in Excel | |||
Importing a file(s) | Excel Worksheet Functions | |||
Importing a file | Excel Worksheet Functions | |||
Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
importing csv file | Excel Discussion (Misc queries) |