View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Reeza Reeza is offline
external usenet poster
 
Posts: 34
Default 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.