Forum Discussion

ineedham's avatar
ineedham
Helper I
9 years ago
Solved

Problem extracting text using MID & FIND/SEARCH when text doesn't contain character

  MESSAGE DESIRED RESULT FORMULA 1 RESULT FORMULA 2 RESULT Certification #1 1 #1 1 Certification #2 2 #2 2 Certification #3 3 #3 3 2017 Live Webinar #1a 1a #1a 1a 20...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    ineedham

     

    Hi, please check the image.

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

ineedham

 

Hi, please check the image.

 

ineedham's avatar
ineedham
Helper I
9 years ago

Apologies,

 

I missed the +1.

 

That worked!

 

Thanks.