On Feb 14, 9:28 am, "Ron de Bruin" wrote:
See the last macro on this pagehttp://www.rondebruin.nl/values.htm#break


Thanks again,
What I really am needing is, when given the following external link:
=[feb14_copy_values_test_a.xls]Sheet1!$B$1

to remove all between the brackets, to leave "Sheet1!$B$1"


Thanks,
Louis