| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input #n
Hello,
I need to input a string that is delimited with spaces. The Input #n statement does an excellent job with a comma delimited file. The example .. Input #1, Myval1, Myval2 .... is great. I need the same thing for a space delimited file. Is there anything as short and succinct as Input #1 Keith |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Input #n
No, but you can use code written by Chip Pearson to specify the delimiter:
http://www.cpearson.com/excel/imptext.htm If it is actually delimited and not fixed width. -- Regards, Tom Ogilvy "keith" wrote in message ... Hello, I need to input a string that is delimited with spaces. The Input #n statement does an excellent job with a comma delimited file. The example .. Input #1, Myval1, Myval2 ... is great. I need the same thing for a space delimited file. Is there anything as short and succinct as Input #1 Keith |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Input #n
HI Tom,
Thanks very much. Keith -----Original Message----- No, but you can use code written by Chip Pearson to specify the delimiter: http://www.cpearson.com/excel/imptext.htm If it is actually delimited and not fixed width. -- Regards, Tom Ogilvy "keith" wrote in message ... Hello, I need to input a string that is delimited with spaces. The Input #n statement does an excellent job with a comma delimited file. The example .. Input #1, Myval1, Myval2 ... is great. I need the same thing for a space delimited file. Is there anything as short and succinct as Input #1 Keith . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
| input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
| Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
| How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
| CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Linear Mode
