Texas Longhorn
Active Member
- Joined
- Sep 30, 2003
- Messages
- 493
I tried searching, but got way too many hits...
In A1 I have the following formula: =+'[year 2003 Commis_October.xls]ema'!$A$1
In B1, I want to extract the string between ] and ' (in this case, ema). How can I do this?
Thanks,
Bill
In A1 I have the following formula: =+'[year 2003 Commis_October.xls]ema'!$A$1
In B1, I want to extract the string between ] and ' (in this case, ema). How can I do this?
Thanks,
Bill