Thread: SEARCH function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
F. Lawrence Kulchar F. Lawrence Kulchar is offline
external usenet poster
 
Posts: 124
Default 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