parsing text return space to space

Hi,

I'm a noob trying to get up to speed on some fairly complicated xlsx files and VBA.

But one thing the expert in the office can't remember is when he has VBA code to look through a .txt file,
return all the text between the white spaces.

currently he has code that will pull a specific number of digits (kinda like mid(4,6) )

this works ok usually but sometimes the number of digits in the txt report we are pulling from changes. and time looking through the code or the txt file eliminates the time saved by using the vba code.


Its probably stupid and easy but google hasn't been any help....

Im looking for the vba command "return all the data between the two spaces regardless of number of digits" i dont have the ability to grab a sample file.

Just like saying =mid(5,*) where star is a wildcard... One that stops when it hits a white space.

This formula will return the part string between the first and the second space in a text string.

Please Login or Register  to view this content.

and you should be able to translate this into a VBA command.

Personally I would probably use the "Text to Column" method with space as a delimiter and take the substring from the second column.

Alf

Hi,

see also Split function …