Concatenate text and a date

		Microsoft Office Forums > Microsoft Excel > Excel
Concatenate text and a date

FAQ

Thread Tools

Display Modes

11-15-2018, 07:52 AM

Joanne

Windows 7 32bit Concatenate text and a date

Office 2010 32bit

Advanced Beginner

Join Date: Jul 2013

Posts: 58

Concatenate text and a date

Hi all

I am trying to concatenate the following, but I can't get my formula to work correctly.

In cell AC3 - the words "Installation"

In cell AF3 - is the installation date
In cell AH3 - the words " Warranty Expires"
In cell AK3 - is the expiration date

Can someone please help me with the correct formula as my dates are appearing as numbers.

Many thanks

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenate	b16	Excel	1	01-09-2017 04:51 PM
how to concatenate text box on new slide	wichitawx	PowerPoint	5	05-19-2015 05:17 AM
Concatenate with @ symbol	anickles	Excel	2	02-06-2015 09:39 AM
Adding text before a date merge field AND fomatting date as well	NikkiR	Mail Merge	1	08-06-2014 07:18 PM
If, move and concatenate in VBA	devcon	Excel Programming	0	07-04-2011 12:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:35 PM.