|
South Central MN | Does the column always say BUSINESS xxxxx MERCHANT where the XXXX is the actual name of the business? We'd need to know several things to really make the formula do what you want. If xxxxx does represent individual business names, do you end up with a list of names like list one below where the number of characters in the string will vary, or like List 2 where the number of characters is constant? Do you really need "business" and "merchant" in your resulting column?
List 1
BUSINESS Sam's Club MERCHANT
BUSINESS BP MERCHANT
BUSINESS Amazon MERCHANT
List 2
BUSINESS Sam's MERCHANT
BUSINESS BPxxx MERCHANT
BUSINESS Amazo MERCHANT
Not really related to your original question, but what is this computer running that it is so old that it doesn't have internet or enough memory for a spreadsheet? Sounds like you could get a Chromebook for $100 and be decades ahead, but I'm guessing there has to be something specific this computer runs that you can't get rid of it. Not trying to tell you how to spend money, I'm just more curious than anything.
| |
|