Hi Kevin,

I have a column of text that all begin and end with a bracket ([]). The text
varies, but the start and finish should all show brackets. How do I automate
the entry of this after all the text is entered. I tried to create a macro by
typing the first bracket, then entering the "end" key and typing the end
bracket.

A formula will do:

="[" & A2 & "]"

Copy down to match your # of rows.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com