SEARCH function
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
|