Tuesday, September 21, 2010

Excel - Join text and date



You can join two or more text strings into one text string using CONCATENATE function
Syntax
CONCATENATE (text1,text2,...)

Example :
=concatenate("info"," inspired")
the result will be infoinspired
or
using &
="info"&"inspired"

But how to join text and date?
Open a worksheet and type as above and use the below formula in cell I4
="Bought by "&" "&F4&" on "&TEXT(G4,"dd-mm-yy")
I have used & and text function in this formula
If you have any problem catching this formula please leave your valuable comment below
Get Free Updates:
We will send a confirmation mail. Please check your inbox/spam folder to confirm it
Related Posts Plugin for WordPress, Blogger...
 

Copyright © 2011 All Rights Reserved | Designed by Amith | Post RSS | Home | About | Disclaimer | Privacy Policy | Contact