| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding tabs in a string from a text file
or even
-Instr(1, WorkResult, vbTab) "mjclare <" wrote: Simon, The tab character is the 9th ASCII value so... modify your statement to be: ... -Instr(1, WorkResult, chr(9)) Mike SimonT wrote: *I have a tab delimited text file which has too many columns so I am trying to right some code to put the remaining columns onto another worksheet in excel. I have got some code which works for a comma delimited text file, but I can't seem to get the same bit of code to work with a tab delimited file. I am trying to get it to recognise the tab in an Instr statement. My current line of code is: WorkResult = Right(WorkResult, Len (WorkResult) - Instr(1, WorkResult, ",")) Changing the "," to "{tab}" or "[tab]" doesn't work, anyone with any ideas, please let me know Thanks SimonT * --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a character in a text string (take3) | Excel Discussion (Misc queries) | |||
| Finding a charcter in a text string | Excel Worksheet Functions | |||
| Finding specific text in a string | Excel Worksheet Functions | |||
| Finding a text string w/in a Cell | Excel Discussion (Misc queries) | |||
| Finding Specific Text in a Text String | Excel Worksheet Functions | |||
![Dave Peterson[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
