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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Store[/TD]
[TD]Desired Output[/TD]
[/TR]
[TR]
[TD]CJ's CVS 3824[/TD]
[TD]CVS[/TD]
[/TR]
[TR]
[TD]Ohio's Best Walmart FC312[/TD]
[TD]Walmart[/TD]
[/TR]
[TR]
[TD]Frederico Sobeys RJ123[/TD]
[TD]Sobeys[/TD]
[/TR]
[TR]
[TD]Dustin Walmart 7682 R2S[/TD]
[TD]Walmart[/TD]
[/TR]
</tbody>[/TABLE]
Is there another way of working with formulas that I'm missing? Is it possible to use arrays with if statements?
Thanks in advance!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Store[/TD]
[TD]Desired Output[/TD]
[/TR]
[TR]
[TD]CJ's CVS 3824[/TD]
[TD]CVS[/TD]
[/TR]
[TR]
[TD]Ohio's Best Walmart FC312[/TD]
[TD]Walmart[/TD]
[/TR]
[TR]
[TD]Frederico Sobeys RJ123[/TD]
[TD]Sobeys[/TD]
[/TR]
[TR]
[TD]Dustin Walmart 7682 R2S[/TD]
[TD]Walmart[/TD]
[/TR]
</tbody>[/TABLE]
Is there another way of working with formulas that I'm missing? Is it possible to use arrays with if statements?
Thanks in advance!