Text function
 

i have a database which i need to extract the supplier name and they are not
in same order for example

RPO-09393-Supplier AAA
980-Supplier BBBBBB
AHU-OIJ-JUH-Supplier CC

As you can see the suppliers name are always at the back, how to build the
formula just to extract the supplier name (different lenght) that always at
the back.

Thanks
Howard

Text function
 

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


"Howard" wrote:

i have a database which i need to extract the supplier name and they are not
in same order for example

RPO-09393-Supplier AAA
980-Supplier BBBBBB
AHU-OIJ-JUH-Supplier CC

As you can see the suppliers name are always at the back, how to build the
formula just to extract the supplier name (different lenght) that always at
the back.

Thanks
Howard

Text function
 

If there is **always** a dash in front of the supplier's name (as you show)
and if your supplier's name **never** has a dash in it, then you can use
this formula...

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

--
Rick (MVP - Excel)


"Howard" wrote in message
...
i have a database which i need to extract the supplier name and they are
not
in same order for example

RPO-09393-Supplier AAA
980-Supplier BBBBBB
AHU-OIJ-JUH-Supplier CC

As you can see the suppliers name are always at the back, how to build the
formula just to extract the supplier name (different lenght) that always
at
the back.

Thanks
Howard

Text function
 

If you do not want the word "Supplier" try this:

=MID(A6,FIND("er ",A6)+3,99)

HTH
Regards,
Howard

"Howard" wrote in message
...
i have a database which i need to extract the supplier name and they are
not
in same order for example

RPO-09393-Supplier AAA
980-Supplier BBBBBB
AHU-OIJ-JUH-Supplier CC

As you can see the suppliers name are always at the back, how to build the
formula just to extract the supplier name (different lenght) that always
at
the back.

Thanks
Howard