characters in text strings

OK, I'm getting really frustrated here... I need to do something REALLY simple.... that ive done 10 million times before. I need to look at a text string in a cell, and do specific actions based on the string in the cell. Easy case statement, right?

Here's where it gets crazy....

the values in the cell are things like #1, #2 PW, 4.5".

VB doesn't like statements like

case #1
case asc(35)&1

I'm completely stuck. I've done a lot of searching, and the only information I seem to find is returning the ascii value, or concatenating an ascii value into a string.... any help is appreciated. thanks in advance!

ugh.... it's been a LONG day..... between the missing quotes, and the fact that the text string is actually "#1 space space space space space space"... it works now. THANKS!

wait.... it doesn't like strings like

case "12" POT                                 "

ugh.....

sorry if I wasn't clear.... the string itself has the quotes in it.... 12" POT....

the double quotes worked. thanks!