So I have the formula listed below, and what shows up. I want to add the & symbol at the beginning of the function and have it add to whatever number the IF statement I have listed below happens to come out as.
=IF(C1="","",IFERROR(CHOOSE(LEN(C1)-LEN(SUBSTITUTE(C1,"*","")),14,16,18,20,22),12))
Example of what is in cell C1 and the output:
_____________
M3848 ***|18|
---------------
Another Example:
__________
M3848 *|14|
------------
And here is what I want to happen, where & = 4
______________
&M3848 ***|22|
----------------
Another Example:
___________
&M3848 *|18|
-------------
How can I make this happen?
Bookmarks