Adding text from one cell to another

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

Thanks for any help.

 

[Nick Hodge]

You only have 14 more groups to go...

 

[Earl Kiosterud]

bt,

YOu can use number formatting if the text is to appear in all the cells.
(This seems to be redundant, but you have your reason, I'm quite sure).

Select the column(s). Format - Cells - Number - Custom:

"Tag Number" General

Substitute other number format codes for General, as needed (0.00, etc).
The cell still contains a number, and can be used mathematically by another
formula.

If you wish to use the formula approach, try

= "Tag Number " & A1

The result of this formula is text, so it can't be used mathematically in
another formula.