Extract char from multicells to build new in another
In column A, i need to build a new char string where the
first three char come from column B, then a dash is
added, and the first 16 char from column C. I couldn't
get the recorder to do this for me.
Example
Column A | Column B | Column C
App-Mushrooms, Stuffed | Appetizer | Mushrooms, Stuffed
Portabello
|