Try the below

=TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",255)),255))

--
Jacob


"Howard" wrote:

i need to extract the supplier name from my database and the supplier that
downloaded from my system which not in a consistant format: -

POK-KIJ-198-BBC Ltd
POI-980-Microsoft Ltd
IUYOP0987-Seach Pvt Ltd

How can i build a formula to extract the supplier name which apparently
always at the back of the text?
Thanks
howard