In , Baffled
spake thusly:

OK Martin, I'll try to past the spreadsheet right here but you might have to
paste it into a larger area to see it spread out. Thanks. Let me know.

Customer B1: =MID(A1,1,FIND(" ",A1)-1) C1: =MID(A1,FIND(" ",A1)+1,50)
USPE SONIA B1: =MID(A1,1,FIND(" ",A1)-1) C1: =MID(A1,FIND(" ",A1)+1,50)
USAIDI L & OPEMAN S B1: =MID(A1,1,FIND(" ",A1)-1) C1: =MID(A1,FIND("

Baffled: when the OP asked you to post sample data, I don't know that
he had in mind to post a long list of unique names of business customers.
That, to me, seems to be a breach of ethics, if not laws.

I know if I were a customer and my name suddenly appeared on the web
on your partial list of customers, I'd be pretty exercised. This seems
to me to be confidential data.

--
dman