Hello,

I have a workbook (US latest month) with text in cell A1. I need to copy part of that text string to cell B3 in a different workbook (Monthly summary). Is it possible to do this using a formula in the destination cell?

Sample original text string in A1 (no quotes): "Merchandise imports and exports between *British Columbia* and *United States*, by Harmonized System section , customs basis, February 2012"
From this, I need to extract "February 2012 to cell B3 in the new workbook.

Many thanks in advance!

Erick