Extracting Text from part of a cell

[Bazzza67]

Hi Board Members

Can I please request your assistance. Having done a search, this type of question is raised frequently, but I haven't quite mastered applying solutins to my needs.

I have cells with variable string length, examples below, I need to extract the full PRJT number including the suffix from each cell, so PRJT1234, PRJT4758 & PRJT3457

Many thanks in anticipation

wydgvxydw PRJT1234 jjjjhffjjjoyk web PRJT4758 ihc hwe

has ffwei fweb PRJT3457 ihc hwe

 

[FormR]

Hi, this assumes that the PRJT numbers are always 8 characters long (like your examples) - this can be made more dynamic if needed.

Book3
	A	B
1	wydgvxydw PRJT1234 jjjjhffjjjoyk	PRJT1234
2	web PRJT4758 ihc hwe	PRJT4758
3	has ffwei fweb PRJT3457 ihc hwe	PRJT3457
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=MID(A1,FIND("PRJT",A1),8)

 

[Tricepsratops]

The function searches for the possition of the word "PRJT..." and for the possition of the space after that word and extracts what is in between them.

Traductor de Formulas - copia.xlsm
	A	B	C	D
1	wydgvxydw PRJT1234 jjjjhffjjjoyk			PRJT1234
2	web PRJT4758 ihc hwe			PRJT4758
3	has ffwei fweb PRJT3457 ihc hwe			PRJT3457
Hoja5

Cell Formulas
Range	Formula
D1:D3	D1	=MID(A1,SEARCH("PRJT*",A1,1),SEARCH(" ",A1,SEARCH("PRJT*",A1,1))-SEARCH("PRJT*",A1,1))

 

[Bazzza67]

Excellent, thank you so much FormR and Triceratops...both worked a dream!