Hi,
Give us more examples.
With given examples, use one of the following formulas:
=SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("-",A1)+1),"^","")
or
=SUBSTITUTE(RIGHT(A1,5),"^","")
Hi,
Give us more examples.
With given examples, use one of the following formulas:
=SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("-",A1)+1),"^","")
or
=SUBSTITUTE(RIGHT(A1,5),"^","")
Bookmarks