Figuring out what contents are in a cell

[dudley18070]

I'm making a schedule for school. The school website will give me an excel document of all the games and practices put in. I download the list and then paste it into a formatting page that will then link to all the other scheduling formats and needs I have.

The time's of the practices come out looking like this " 3:15PM- 4:15PM"

But when I try to reference that text into a conditional format it doesn't recognize. It doesn't matter what format the cell is in (time, text, general), even copying and pasting the time exactly into a find and replace will not find that one cell I just copied it from.

HOW DO YOU FIND WHAT'S CONTENTS ARE IN A CELL THAT CANT BE COPIED AND SEARCHED?!?!

 

[pgc01]

Hi
Welcome to the board

Sorry, not clear.

Let's say that a cell in column A has the value

" 3:15PM- 4:15PM"

(without the quotes) then try in B1

=MATCH(" 3:15PM- 4:15PM",A:A,0)

You should get the row where the value is.
Please try.

 

[dudley18070]

So what I get when I copy and paste is

=MATCH( "3:15PM-
4:15PM",D:D,0)

not =MATCH( "3:15PM- 4:15PM, D:D,0)

That's after copying and pasting into the cell formula exactly what the report outputs from the website.

It looks like it's adding a return?

Anyway the result is #N/A in the cell. What is this strange beast enigma value in the cell?!