Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test if a string contains only whitespaces
Does Excel VBA have a built-in function to test if a
string variable contains ONLY whitespace characters? For my purposes, a whitespace character can be any one of the following: space, tab, or enter (carriage return). I know regular expressions solves this easily, but I do NOT want to use regular expressions for this. I'm just curious if Excel has a built-in function to test if a string contains 1 or more of the above whitespace characters. Thank you. Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Test for string of space chars? | Excel Programming | |||
Test for NULL string? | Excel Programming | |||
extract cusotmer name from test string | Excel Worksheet Functions | |||
logical test and concatenate(string) | Excel Discussion (Misc queries) | |||
Test String | Excel Discussion (Misc queries) |