Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatenate text and number

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Cell A1 contains the label: July
Cell A2 contains the number: 2002

I want cell A3 to concatenate the first two cells, so that A3 contains the label: July 2002

Can someone please help me with the formula?
 
Hi pbbwg,

This is the formula you need...

+A1&" "&@STRING(B1,0)

Regards, ...Dale Watson

HOME: nd.watson@shaw.ca

 
Thank you so very much, Dale, for your quick reply. This works perfectly.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top