How can I compare a string in a cell to another string?

		Microsoft Office Forums > Microsoft Word > Word VBA
How can I compare a string in a cell to another string?

FAQ

Thread Tools

Display Modes

04-10-2017, 07:29 PM

macropod

Windows 7 64bit How can I compare a string in a cell to another string?

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Try:
str = Split(.Tables(i).Cell(2, 1).Range.Text, vbCr)(0)

As for 'Left(str, len(str) - 1)', you'd need to use 'Left(str, len(str) - 2)', since cells are terminated by a Chr(7) & Chr(13) pair.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

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
Rule: Look for this number string and only this number string	kcm5153	Outlook	3	03-30-2015 10:15 PM
Text in string	projectpupil7	Excel	7	11-23-2014 12:03 AM
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
using a cell content as a string with COUNTIF	geoffm	Excel	1	08-16-2011 11:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:18 PM.