Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-15-2018, 09:43 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Concatenate text and a date Windows 7 64bit Concatenate text and a date Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

The same way Xor added a space in each formula


=(AC3&" "&TEXT(AF3,"dd-mm-yyyy")) &" "&(AH3&" "&TEXT(AK3,"dd-mm-yyyy"))
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 11-15-2018, 09:45 AM
Joanne Joanne is offline Concatenate text and a date Windows 7 32bit Concatenate text and a date Office 2010 32bit
Advanced Beginner
Concatenate text and a date
 
Join Date: Jul 2013
Posts: 58
Joanne is on a distinguished road
Default

I see, thank you for your help.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenate text and a date 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 text and a date 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 11:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft