Formula Question
On May 14, 1:15*pm, Nikki wrote:
What formula could I use to pull 03275 from the below contents of a cell?
EA_1045_02949_03275 (John Doe)
If (John Doe) is part of the text.....
=MID(B10, LEN(B10)-FIND(" (", B10,1)+6, 5)
If the _XXXXXX is variable length you need a different approach
though.
|