Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 04-08-2016, 06:46 PM
JennEx JennEx is offline Mergefield Consisting of Concatenated Strings Windows XP Mergefield Consisting of Concatenated Strings Office 2013
Competent Performer
Mergefield Consisting of Concatenated Strings
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

Hey Paul ...

This is what I came up ....

I got the same results as you ... and they weren't really the results I was looking for.

With my data, one record with r1_relchg = "REL", I was given the following results with both scripts:

12:00 A-12:00 A

r1_srl = 9:30 AM ... confirmed time value, no other dta in the column, just blank cells.
r1_sru = 10:00 AM ... confirmed time value, no other dta in the column, just blank cells.

Real estate in the cell is tight, so I am also trying to eliminate the space between the number and the AM/PM.
Attached Files
File Type: docx 12.docx (15.7 KB, 9 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mergefield Consisting of Concatenated Strings Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM
Save merged document as concatenated merge field values texas791 Word VBA 4 02-25-2014 07:35 PM
Mergefield Consisting of Concatenated Strings Search with multiple strings silverspr Excel 7 03-03-2013 04:45 PM
Concatenated data in subsequent rows doorsgirl Excel 4 09-15-2011 10:37 PM
Mergefield Consisting of Concatenated Strings update style of all strings available between two specific strings vikrantkale Word 1 03-28-2011 06:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:22 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