Help in cut string

[DaveNguyen]

Hi,

I'm looking for a generic function that can help me cut a string from the whole string that varies.
The string needs to be cut is A: monitor.task.A.B
Notice that monitior.task will always remain the same while A and B are changing.
E.g: monitor.task.vl_h.sql.0010
monitor.task.djcat_hh.emailsub

My idea is to cut the string between the second and third dot (.) but I don't know which function in excel can help me do it.

Thanks for any help.

[tigeravatar]

DaveNguyen,

If the text is in A1:
=MID(A1,FIND(".",A1,FIND(".",A1)+1)+1,FIND(".",A1,FIND(".",A1,FIND(".",A1)+1)+1)-FIND(".",A1,FIND(".",A1)+1)-1)

Note: if the text string does not have three periods, the formula will return an error.

Hope that helps,
~tigeravatar

[Haseeb Avarakkan]

Hello, Try also;

=TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",100)),200,100))

[DaveNguyen]

Hi,
Thanks for the help. All your functions works.
As I said "monitor.task." remains the same, so I figured this myself:
MID(A1,14,(FIND(".",A1,14) - 14))
14 is the character right after the second dot (.)
Cheers.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.