ScatmanKyle
Board Regular
- Joined
- Oct 26, 2015
- Messages
- 65
- Office Version
- 365
- Platform
- Windows
Let's say I have the store column below. I'm trying to make a formula that will scrub the column and return an output with just the type of store as shown in the "Desired Output" column. Because the amount of words before/after the type varies, I couldn't use the mid function to look for a set number of spaces. I was trying a nested IF statement using the SEARCH and ISNUMBER function, but currently there are 11 different outputs and Excel won't allow that level of nesting.
<tbody>
</tbody>
Is there another way of working with formulas that I'm missing? Is it possible to use arrays with if statements?
Thanks in advance!
Store | Desired Output |
CJ's CVS 3824 | CVS |
Ohio's Best Walmart FC312 | Walmart |
Frederico Sobeys RJ123 | Sobeys |
Dustin Walmart 7682 R2S | Walmart |
<tbody>
</tbody>
Is there another way of working with formulas that I'm missing? Is it possible to use arrays with if statements?
Thanks in advance!