Extract string before and after a period

[bchi99]

Hello, i need help selecting a string of characters before and after a period.

Sample string is:

hello world 12345.1234 hello earth

I would like the expression to return: 12345.1234



Thanks!

[June7]

You should become familiar with all the string manipulation functions and how to use them. Once the functions are understood, just a matter of determining the consistencies that can be depended on and applying logic. The examples given in your other thread should have been a good introductory primer.

There is only the one period? Always the same number of digits?

Mid(x, InStr(x, ".")-5, 10)

[bchi99]

Thanks that works. Yes its just very confusing to me. I'm just starting out.

[June7]

Practice, practice, practice!

Learn how to use the VBA Immediate Window to test expressions. That's where I verified the suggested expressions I posted. It looks like:

x="hello world 12345.1234 hello earth"
?Mid(x, InStr(x, ".")-5, 10)
12345.1234