SEARCH function
I will answer this query myself:
the ("") is not a space at all...I need to use (" ") with the "space in there.
Thanks,
FLKulchar
"F. Lawrence Kulchar" wrote:
I am using the SEARCH function to search for a space ("") within a cell such
as follows:
A
1 I LOVE YOU
=SEARCH("",A1)
UNFORTUNATELY, IT IS FINDING THE SPACE IN THE FIRST (1ST) POSITION.
THIS IS TRUE NO MATTER WHAT THE CELL STATES...IN OTHER WORDS, FOR ALL CELLS,
A SPACE IS ALWAYS FOUND IN THE FIRST POSITION.
How is this "dilemma" corrected?
Thanks,
FLKulchar
|