Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I automatically put square brackets around field name...
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I automatically put square brackets around field name...
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I automatically put square brackets around field name...
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 "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I automatically put square brackets around field name..
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I automatically put square brackets around field name..
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I automatically put square brackets around field name..
Give this man a fat cigar!!!! Great just what I was after, many many thanks
Dave for answering my question. Mike "Dave Peterson" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to fill the matched field automatically | Excel Discussion (Misc queries) | |||
Pivot Table Page Field Area Broken | Excel Discussion (Misc queries) | |||
Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Comment Field | Excel Discussion (Misc queries) | |||
How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) |