I have one column of numbers and need to take those numbers from one
column and have another cell copy those numbers to another cell and add
some text to it.

Example:

A1 = 123456

need to have cell B1 take the number in A1 and look like this

B1 = 'Tag Number' = "123456" OR

I've done this before with adding regular text but seem to be having a
problem now with adding the quotation marks, excel wants to think those
are part of the fomula.

Thanks for any help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Answered in misc and worksheet.functions. As you can see, multi-posting is
a waste as most readers read all groups.

For newsgroup etiquette, see http://www.cpearson.com/excel/newposte.htm

--
HTH
Nick Hodge
Southampton, England



"bt707" wrote in message
...
I have one column of numbers and need to take those numbers from one
column and have another cell copy those numbers to another cell and add
some text to it.

Example:

A1 = 123456

need to have cell B1 take the number in A1 and look like this

B1 = 'Tag Number' = "123456" OR

I've done this before with adding regular text but seem to be having a
problem now with adding the quotation marks, excel wants to think those
are part of the fomula.

Thanks for any help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

See my reply in misc.

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"bt707" wrote in message
...
I have one column of numbers and need to take those numbers from one
column and have another cell copy those numbers to another cell and add
some text to it.

Example:

A1 = 123456

need to have cell B1 take the number in A1 and look like this

B1 = 'Tag Number' = "123456" OR

I've done this before with adding regular text but seem to be having a
problem now with adding the quotation marks, excel wants to think those
are part of the fomula.

Thanks for any help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

I do not quite follow what you want cell B1 to contain in
your example but if you mean you want it to display EXACTLY
what you have below then just format that cell, using the
Format -- Cells -- Custom menu item, as

"'Tag Number ='" \"0\" "OR"

Then enter into cell B1 the formula

= A1


I am pretty sure that is not what you want but you can probably work it
out from that.

The other option is to enter into cell B1 the formula

="'Tag Number = ' """ & TEXT(A1,0) & """" & "OR"

Good luck.

Chrissy.

"bt707" wrote in message ...
I have one column of numbers and need to take those numbers from one
column and have another cell copy those numbers to another cell and add
some text to it.

Example:

A1 = 123456

need to have cell B1 take the number in A1 and look like this

B1 = 'Tag Number' = "123456" OR

I've done this before with adding regular text but seem to be having a
problem now with adding the quotation marks, excel wants to think those
are part of the fomula.

Thanks for any help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/