Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-10-2017, 06:55 PM
Amitti Amitti is offline How can I compare a string in a cell to another string? Windows 10 How can I compare a string in a cell to another string? Office 2010 32bit
Novice
How can I compare a string in a cell to another string?
 
Join Date: Mar 2017
Posts: 7
Amitti is on a distinguished road
Default How can I compare a string in a cell to another string?

Hi All,



This may be a silly question but I'm really stuck and need your help.

I'm trying to compare a string in a cell to another string to see if they match but can't seem to be able to because the comparison always fails. I must be using the wrong call. Like this:


'assume i and str are declared
With ActiveDocument
str = .Tables(i).Cell(2, 1).Range.Text
Select Case str
Case "AAA"
'do something
Case "BBB"
'do something
End Select
End With

I also tried Left(str, len(str) -1) to try and get rid of the non-printable character at the end of the string in the cell but it didn't work for me either.
Is there an easy way to compare a string in a cell to another string?

Thank you in advance.
Reply With Quote
 

Thread Tools
Display Modes


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
How can I compare a string in a cell to another string? Rule: Look for this number string and only this number string kcm5153 Outlook 3 03-30-2015 10:15 PM
How can I compare a string in a cell to another string? Text in string projectpupil7 Excel 7 11-23-2014 12:03 AM
How can I compare a string in a cell to another string? 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
How can I compare a string in a cell to another string? 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 06:32 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