How to copy partial text from a cell into a cell in a different workbook

[erickpay]

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

[ron2k_1]

Can I suggest you insert the formula anywhere you can on your first workbook. It will give you everything after the last coma ",":

=TRIM(MID(A1,FIND("=",SUBSTITUTE(A1,",","=",LEN(A1)-LEN(SUBSTITUTE(A1,",",""))))+1,256))

Then you can easily copy, and paste values into the other workbook. If you don't mind having external links you can insert the above formula in your second workbook - naturally you need to change the reference A1 for the link reference to the other workbook.

[erickpay]

Excellent. Works well. Thanks Ron!

[Haseeb Avarakkan]

Also:

=TRIM(RIGHT(SUBSTITUTE(A1,",",REPT(" ",250)),250))

Will extract the value after the last comma,