I have a spreadsheet does sales quotes and I wanted to create a unique quote name that get concatenated with data from multiple cells (using "&" between the multiple fields. The first piece of data is the Company Name and I want to pick the first four, non-blank characters. I use Left(b2,4) and this works for most cases.
Here are example of what I want:
Philadelphia Phillies ---> now produces "PHIL", which is OK.
Washington Capitals ---> now produces "WASH"
Los Angeles Lakers ---> now produces "LOS " but I would like "LOSA"
San Francisco 49ers ---> now produces "SAN " but I would like "SANF"
El Paso Chihuahuas ---> now produces "EL P" but I would like "ELPA"
How do I ignore the spaces after the second or third character and fill in the appropriate number of characters after the space?
Thanks in advance for your help!!!
Jim
Bookmarks