Thread
:
taking one cell and adding text to it
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nick Hodge[_3_]
external usenet poster
Posts: 13
taking one cell and adding text to it
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/
Reply With Quote
Nick Hodge[_3_]
View Public Profile
Find all posts by Nick Hodge[_3_]