taking one cell and adding text to it

  • Thread starter Thread starter bt707
  • Start date Start date
B

bt707

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.
 
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
 
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
 
I read the OPs post to mean that he wanted all the quotes there
too.

Chrissy.


CLR said:
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
Click to expand...
 
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 said:
I read the OPs post to mean that he wanted all the quotes there
too.

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