Text to Display
 

Hi

In Column J, I have webpage hyperlinks. In edit the hyperlink, There is some
text in, Text to Display,
In this text there is some between Brackets (***) I'd like to run a macro
that goes down column J
and gets all the characters between the Brackets and put them in column C.
So J1 would
go into C1 and Down .

Example:

J1 Text to display is

This is a Test (0A1) (AA1)

Result would be in C1

0A1 AA1

or

AA1

if just 1 item in brackets

Thanks in advance

Dave