Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro Text into Excell
I have a .txt file that I can bring into a Excell workbook
but the letter and such are chopped up...Does anyone know how I can import the Text and read it exactly as in the Text File? Thanks in advance. |
#2
|
|||
|
|||
When you open a text file in Excel the Text Import wizard should start up.
You can prevent any parsing by selecting Delimited as the file type and then uncheck all delimiters on the second page of the wizard. If you want to do this by macro you might start by recording a macro as you manually do an import. -- Jim Rech Excel MVP "Krefty" wrote in message ... |I have a .txt file that I can bring into a Excell workbook | but the letter and such are chopped up...Does anyone know | how I can import the Text and read it exactly as in the | Text File? | | Thanks in advance. |
#3
|
|||
|
|||
If you want to import the text file just into column A, just hold down the
shiftkey when you click on the Open button (in the file|open dialog). This works if the file isn't tab delimited. Krefty wrote: I have a .txt file that I can bring into a Excell workbook but the letter and such are chopped up...Does anyone know how I can import the Text and read it exactly as in the Text File? Thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro help | Excel Discussion (Misc queries) |