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.

I had to post this one again, for some reason it didn't show up the
first time I posted it.

Thanks for any help.



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

13!

--
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.

I had to post this one again, for some reason it didn't show up the
first time I posted it.

Thanks for any help.



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

To merge text and numbers into a single cell you should
use the concatenate function. Excel provides help on the
functions and even will help you build the function. But
if in cell a1 you have "123456" and in cell a2 you
want "'Tag Number' =" then in cell a2 use this formula:
=CONCATENATE("'Tag Number' = ",A1)

Stephen Datexan James


-----Original 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.

I had to post this one again, for some reason it didn't
show up the
first time I posted it.

Thanks for any help.



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

.

You can add text to a number value in a cell by doing a Custom Format of
"Tag Number = "######
With 123456 entered in the cell, it will then read Tag Number = 123456

Vaya con Dios,
Chuck, CABGx3



"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.

I had to post this one again, for some reason it didn't show up the
first time I posted it.

Thanks for any help.



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

I read the OPs post to mean that he wanted all the quotes there
too.

Chrissy.


"CLR" wrote in message ...
You can add text to a number value in a cell by doing a Custom Format of
"Tag Number = "######
With 123456 entered in the cell, it will then read Tag Number = 123456

Vaya con Dios,
Chuck, CABGx3



"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.

I had to post this one again, for some reason it didn't show up the
first time I posted it.

Thanks for any help.



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

Sorry, if that be the case then the Custom Format should read:

"'Tag Number' = "''######'' "OR"

With 123456 in the cell, it will display 'Tag Number' = "123456" OR

Note that the lead-in is a double quotation mark and an apostrophe, and the
group following the = sign is a double quotation mark and two apostrophe's,
and then two apostrophes after the ######......the rest are as they appear.

A little messy but seems to do the job.......

Vaya con Dios,
Chuck, CABGx3



"Chrissy" wrote in message
...
I read the OPs post to mean that he wanted all the quotes there
too.

Chrissy.


"CLR" wrote in message
...
You can add text to a number value in a cell by doing a Custom Format of
"Tag Number = "######
With 123456 entered in the cell, it will then read Tag Number =
123456

Vaya con Dios,
Chuck, CABGx3



"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.

I had to post this one again, for some reason it didn't show up the
first time I posted it.

Thanks for any help.



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

Actually, you only need one # or even a 0 would work.

It really depends on what he wants as his original post
was unclear. I also suspect that there is no need to have
two columns with the data in it - one with the custom
formatting as just formatting the original data would have
the same affect.

Chrissy.


"CLR" wrote in message ...
Sorry, if that be the case then the Custom Format should read:

"'Tag Number' = "''######'' "OR"

With 123456 in the cell, it will display 'Tag Number' = "123456" OR

Note that the lead-in is a double quotation mark and an apostrophe, and the
group following the = sign is a double quotation mark and two apostrophe's,
and then two apostrophes after the ######......the rest are as they appear.

A little messy but seems to do the job.......

Vaya con Dios,
Chuck, CABGx3



"Chrissy" wrote in message
...
I read the OPs post to mean that he wanted all the quotes there
too.

Chrissy.


"CLR" wrote in message
...
You can add text to a number value in a cell by doing a Custom Format of
"Tag Number = "######
With 123456 entered in the cell, it will then read Tag Number =
123456

Vaya con Dios,
Chuck, CABGx3



"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.

I had to post this one again, for some reason it didn't show up the
first time I posted it.

Thanks for any help.



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