Extract Part of string

[AlexanderBB]

I can think of many ways to do this but wonder what is the best/most efficient ?

I want everything after the first space and before the first 2 spaces.
The spaces have been validated

 

[Phuoc]

Extract_Part = Split (str) (1)

 

[kvsrinivasamurthy]

Text in A3. In B3

=MID(LEFT(A3,FIND("  ",A3)-1),FIND(" ",A3)+1,200)

 

[Phuoc]

Try this formula:

=TRIM(MID(SUBSTITUTE(A3," ",REPT(" ",250)),250,250))

 

[AlexanderBB]

item = Mid(item, (InStr(item, " ")))
tem = Split(item, " ")(0)
Was the best I could come up with. Can't use an Excel Formula in VBA (or can I?)

 

[Phuoc]

See post #2:

''item = Mid(item, (InStr(item, " ")))
tem = Split(item, " ")(1)

 

[AlexanderBB]

That only gets the first word.

 

[Phuoc]

Add Trim:
tem = Split(Trim(item), " ")(1)