Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Problem Spaces
Hi,
I'm comparing the string values in a column of Dealer Names to those stored in an Array of Dealer Names. My code isn't finding any matches (although there are plenty) & I think it is something to do with this; When debug it & step through, I notice that the value of the string in my array looks something like this; "Joe Bloggs & Sons Ltd" but the variable is returning Dealer names from the column that look something like this; "Joe Bloggs & Sons Ltd " I'm guessing the amount spaces between the last letter of the string & the quotation mark is why no matches are being found. How can I solve this please, "MERRY XMAS EVERYONE ! " :-) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing from Excel Sheet Problem | Excel Discussion (Misc queries) | |||
Add spaces for specific fields to paste in | Excel Discussion (Misc queries) | |||
how do I remove empty spaces trailing a text string? | Excel Worksheet Functions | |||
Stripping out imbedded spaces in a cell/row | Excel Worksheet Functions | |||
remove spaces in text in excel | Excel Discussion (Misc queries) |