Extract Supplier Name

[Howard]

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

 

[Rick Rothstein]

If you look down to the first post you made with this question (you called
the subject "Text function"), you will see the two answers you already got
to it.

 

[Jacob Skaria]

Try the below

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