Adding text to a cell

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

Thanks for any help.
 
How about something like this ="Tag Number"&" "&A1

--
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 **
 
Paul

I think the OP wanted the tag number in "" too. I couldn't work out what
the OR was though, so maybe your solution was correct

--
HTH
Nick Hodge
Southampton, England
(e-mail address removed)


Paul B said:
How about something like this ="Tag Number"&" "&A1

--
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 **
Click to expand...
 
Try,

="'Tag Number'= "&""""&A1&""" OR"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Nick, I was not sure myself, looks like it was posted on different groups so
maybe one of the answers will be right!

--
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 **
Nick Hodge said:
Paul

I think the OP wanted the tag number in "" too. I couldn't work out what
the OR was though, so maybe your solution was correct
Click to expand...
 
Back
Top