The easy one first:
=""""&A1&""""
or
=char(34)&a1&char(34)

char(34) is the quotation mark.

You can use the autofill button on the lower right corner of the activecell (b1)
and click and drag that down the column. Your formula will adjust for each
cell.

Debra Dalgleish has instructions with pictures:
http://contextures.com/xlDataEntry01.html#Mouse

publisher 2003 user wrote:

Yes got that to work but how do I copy several names across - say I have
names in A1, A2, A3, A4 etc going down to say A145! do I have to change the
formula ="["&A1&"]" to include all the other rows, if you get what I mean or
have I got to do something else?

As a second question what would be the formula for putting quotation marks
around the field - I tried ="""&A1&""" but didn't work.

I'm using excel 2003, and just highlighting the A column with mouse, copy
then highlight column B, paste, to complete move (to answer CLR's question)

"TrevorM" wrote:

Hi

="["&A1&"]"

where a1 is the cell reference



"publisher 2003 user" wrote:

Hi. I'm trying to simply copy a list of names from column A then paste them
into column B but when the names appear in column B they are surrounded by
square brackets []. I'm fairly new to Excel so please forgive me if this is a
stupidly simple thing to do!

Any help would be much appreciated.

Many thanks

--

Dave Peterson