ExcelBanter - SEARCH function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - SEARCH function (https://www.excelbanter.com/excel-programming/373399-search-function.html)

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

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