Identifying line feeds in an linked excel data within a quer

[kaykrazy]

I have a linked excel table that has a cell with work address. The first line is the mailstop. There is chr$(10) there. (I used the "View Cell Contents" add-in and verified). I need to extract this by itself.
I tried using the instr to identify it but it doesn't recognize the value.

I've tried:

xMailStop: IIf(InStr([Work Address],char$10),"Y","N")
xMailStop: IIf(InStr([Work Address],vbcr),"Y","N")

in both cases I get the "enter parameter value" dialog box.

Thanks

Kathy Zawacki