ignoring cells

[Luis939]

now i need to know how i can ignore blanks, becuase one problem that i have found, which annoys me very much and is sometimes not easy to detect at first is, lets say you have 2 strings, that are supposed to be the same "string" and "string ", but they are not the same because the 2nd instance of string has the space right after it, so is there anyway of saying, take the first string in the cell, and ingnore all blanks so that you only have a set of characters, and find its match, ignoring its blank spaces as well, or is it not possible because the 2nd string has the blanks and you cant tell it ahead of time to ingore that blanks, i was hoping theyre would be a mechanism that would search for strings, ingoring blanks, is there?? thanks

 

[RobBroekhuis]

The trim() function removes any spaces on the exterior of a text string. If you apply trim() to both strings you are comparing, any spaces will be ignored, e.g.

if trim(String1)=trim(String2) then
msgbox("Found a match!&quot
end if
Rob

 

[Stretchwickster]

Trim(string) removes leading and trailing spaces Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)

 

[Luis939]

well what if i want to use that function in the activecell
i tried
activecell.formula = "=trim(activecell)"
activecell.formula = "=trim(activecell.value)"
activecell.value = "=trim(activecell)"
activecell.value = "=trim(activecell.txt)"

nothing works, how can i achieve this, thanks

 

[Luis939]

nevermind i got it thanks