Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to test 2 columns of data in my spreadsheet.
Column "A" is definded by the string "S_Create", works great. Columns "D" and "E" are defined as strings as well. Column D contains text followed by multiple spaces. My "And" test fails becase of the trialing spaces. How do I test for "contains characters" vs. = Or.. how do I search for a string plus any other characters ex. "Feature Defintion*" (which did not work). Thanks, Ron If s_Create = "X" And s_Col_D = "Feature Definition" Then Print #1, s_Col_D & "=" & s_Col_E; |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
testing for left 2 characters in set of 3 choices | Excel Worksheet Functions | |||
convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions |