Thread: Help with Formula to extracting text from text string
View Single Post
 
Old 01-13-2019, 01:33 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
You may be right. Only OP knows.

Anyway I think you should keep your sarcasm for yourself. Your know-all attitude is a bit tiring.

Still this is about 20% shorter
=MID(B3,FIND("Invoice",B3)+7,FIND(":",B3,FIND("Inv oice",B3))-FIND("Invoice",B3)-7)
Reply With Quote