Just copy that formula and paste it down, it should format all of it.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Justin R" wrote:

I just cant figure out the right formula for adding quotes to multiple rows
of pre-existing data The data is there now in this form EXAMPLE and it needs
to look like this "EXAMPLE"; the formula that i've been working with is
=""""&A2&""";" but of corse it can't be applied to more than one cell and
it needs to work for thousands. Any help would be great.