Getting Certain Text from cell

[volsfan210]

Hi -

Have a group of cells that have text in them but I only wont certain text from the cells.

I only need to pull the "Test 1, Test 2, etc" out of each cell.

The problem is the "Test 1" isnt the same number from the front on each one so a Trim or Mid hasnt worked for me.

Any ideas!

Thanks as always!!

 

[volsfan210]

Hi, this might work for you.

Book4
	A	B
1	WBS: 000123456.ME.ABC Test Excel Data	Test Excel Data
Sheet1

Cell Formulas
Range	Formula
B1	B1	=TEXTAFTER(TRIM(A1)," ",2)

Perfect that works!!! Thank you!