how do I automatically put square brackets around field name...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
What version of Excel are you using?.....and give us the exact steps you are
doing to perform the copy and paste...........

Vaya con Dios,
Chuck, CABGx3
 
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 said:
Hi

="["&A1&"]"

where a1 is the cell reference



publisher 2003 user said:
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
Click to expand...
Click to expand...
 
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
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 said:
Hi

="["&A1&"]"

where a1 is the cell reference



publisher 2003 user said:
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
Click to expand...
Click to expand...
Click to expand...
 
Give this man a fat cigar!!!! Great just what I was after, many many thanks
Dave for answering my question.

Mike

Dave Peterson said:
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
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 said:
Hi

="["&A1&"]"

where a1 is the cell reference



:

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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top