View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kat[_7_] Kat[_7_] is offline
external usenet poster
 
Posts: 1
Default 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