Deleting all text in string prior to final ocurrence of a symbol?

[jmckeone]

I'm working with a long string and need to, by formula if possible, remove all text prior to the final occurrence of a colon ) ... and the colon.

Example string below though not all strings follow same format with the exception of what I need being at the end.

MANUFACTURING, INC@2343 Hoover DR Arkon OH 99999:61.L1XX.001728..TWCC

 

[István Hirsch]

Give this a try:

=REPLACE(A2,1,LOOKUP(2,1/(MID(A2,ROW($1:$250),1)=":"),ROW($1:$250)),"")

New data should be put at the end of the list, do not insert them. Increase 250 to a higher value, if there are strings which are longer than 250 characters.