Hi,
If you want to compare multiple values I would suggest you to use Dictionary object.
And to avoid spaces you can use Trim function and to make the comparision case insensitive you can use lcase or Ucase on both the values to be compares that way it will convert the value in lower case or upper case and you can compare them.
let me know if u have any queries regarding this.
If you want to compare multiple values I would suggest you to use Dictionary object.
And to avoid spaces you can use Trim function and to make the comparision case insensitive you can use lcase or Ucase on both the values to be compares that way it will convert the value in lower case or upper case and you can compare them.
let me know if u have any queries regarding this.