B
Beverly-Texas
Hello,
I have searched the web but can't seem to find the solution for this
problem. I have a string of data in a column of cells that look like this:
COMPANY NAME Contact Person Address
COMPANY NAME Contact Person Address
I need to pull the company name (which are in all caps) from the first part
of this string for each cell. How do I get Excel to pull the company name
(anywhere from 1 words to 6 or 7 words) and leave the rest?
Thanks in advance for your help!
I have searched the web but can't seem to find the solution for this
problem. I have a string of data in a column of cells that look like this:
COMPANY NAME Contact Person Address
COMPANY NAME Contact Person Address
I need to pull the company name (which are in all caps) from the first part
of this string for each cell. How do I get Excel to pull the company name
(anywhere from 1 words to 6 or 7 words) and leave the rest?
Thanks in advance for your help!