In A1 I have a name, "Bob Smith".
In B1, I'd like a formula that creates "B.S." I know it involves using MID, FIND, in some delicious mixture of commas and parentheses and concatenation.
I'd also like to get a handle on the formulas to put the "B" in C1 and the "S" in D1.
Thanks for the help.
In B1, I'd like a formula that creates "B.S." I know it involves using MID, FIND, in some delicious mixture of commas and parentheses and concatenation.
I'd also like to get a handle on the formulas to put the "B" in C1 and the "S" in D1.
Thanks for the help.