Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 01-30-2017, 11:05 AM
aramaglia aramaglia is offline String will not fully concatenate Windows 7 64bit String will not fully concatenate Office 2016
Novice
String will not fully concatenate
 
Join Date: Jan 2017
Posts: 8
aramaglia is on a distinguished road
Default

Apparently the dot at the end of the text is the character for table end, which is showing up when i call the cell text. There is another character at the end too which I'm guessing marks the end of the cell. To workaround this I used the Left() function to eliminate the last 2 characters of the string:

Code:
QN = Left(ThisDocument.Tables(1).Cell(2, 2).Range.Text, Len(ThisDocument.Tables(1).Cell(2, 2).Range.Text) - 2)
Reply With Quote
 

Tags
concatenate, saveas, word to pdf



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find all string within string. PRA007 Word VBA 18 02-12-2016 08:11 PM
String will not fully concatenate Format Painter must be used twice to work fully Jim_H Word 5 04-13-2015 04:41 PM
String will not fully concatenate Way to search for a string in text file, pull out everything until another string? omahadivision Excel Programming 12 11-23-2013 12:10 PM
String will not fully concatenate How to fully justify columns empressive Word 10 01-17-2012 09:17 PM
String will not fully concatenate Outlook 2007 Not Fully Closing LabanM Outlook 1 09-28-2010 02:27 PM

Other Forums: Access Forums

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