Extraction Logic from Text

[Alka Bajaj]

Hi Expert,

How can I extract a set of characters from a string of text?

Example:
I have a following column of text data, wherein each cell text has 4 digit number in it.

1.Missing Information- 0006 Please check the record
<TABLE dir=ltr cellSpacing=0 cellPadding=2 width=542 border=0><TBODY><TR><TD height=16>

2.ESS should not be checked - 0655 ESS Settings Remuneration Statement​

​

​

​

​

</TD></TR><TR><TD height=16>

3.Job must exist when position is not 99999999 - 0001 Org. Assignment​

​

​

</TD></TR><TR><TD height=16>

4.Email Address can only exist when Username exists - 0105 Communication​

​

​

</TD></TR></TBODY></TABLE>

Expected Outcome:
0006
0655
0001
0105

Appreciate your guidance on above.

Many thanks!

Regards,
Alka

 

[njimack]

Assuming the 4 digit number is always preceded by " - "
=MID(A1,FIND(" - ",A1)+3,4)

 

[Alka Bajaj]

Many Thanks Neil.

Your formula is working partially, following are the end result

06 P
655
001
105

Expected Outcome
0006
0655
0001
0105

How can I extract same as above. Appreciate your help.

Regards
Alka

 

[Gerald Higgins]

I tested NJIMacks suggestion and for me, it returns exactly what you say is the Expected Outcome.

Are you using it exactly as Neil described ? or are you doing something slightly different ?

 

[njimack]

Does your data contain " - " (space dash space) immediately before the 4 digits?

 

[Alka Bajaj]

It works fine now. Thanks so much.