Excel Function to Remove first characters from text ?

[Maverick27]

Hi - anyone care to share an Excel Function to remove the Left Chars upto the 1st "M:" char from Left ?

The Final Output:

M: +254 (0)716 687 248 , M: +254 (0)716 686 254 , M: +254 (0)724 477 663 , , , J.K.I.A Branch , M: +254 (0)

The Excel data is on Col AH with 500 rows.

Thanks in Advance

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

="M:"&TEXTAFTER(AH2,"M:")

if you have 365

 

[Fluff]

Another option if you have an older version of Excel.

=MID(AH2,FIND("M:",AH2)-1,1000)

 

[Maverick27]

Hi Fluff - I have updated my A/C showing which version of Excel i'm using.

This Function works since I'm using Excel 2013

Thanks Heaps !!

=MID(AH2,FIND("M:",AH2)-1,1000)

 

[Fluff]

Thanks for that