Need a function/suggestion for specific spreadsheet task please.

[roma92]

I have a dilemma with excel that I could really use some suggestions on
Why I need to do this would be too long of an explanation so I will ge
right to the question/example.

I have a column with vendor names. 25% of the names in the fields ar
as such: SMITH, JOHN
essentially I can write a simple enough formula such as:
=SUBSTITUTE(B2,", ",",")
this will eliminate the space after the comma as the format we need i
FNAME,LNAME with no space after the comma. No problem, but here's wher
it gets complicated. the other 75% of the column has vendor names wit
a large variation such as WIDGET PRODUCT, ACME INC, WIDGET-ACME, ACM
SUPPLIES AND WAREHOUSE CORP. ect... Where I am at a loss for ideas,
need to be able to extract the 25% FNAME,LNAME to their own column s
that I end up with one column with just names and another with al
else.

I need to be able to do this by formula as I have over 10,000 vendor
so hand picking is not an option as well as needing to do this multipl
times to multiple vendor files.

Has anyone any suggestions/ideas?

Thanks ahead of time

 

[Frank Kabel]

Hi
is there any indication if the entry is a company or a name? If not I
don't see a way to do this automatically.