need a definitive answer on finding end line.

[ulao]

I'm using this.
=SUBSTITUTE(INDIRECT(ADDRESS(ROW(),COLUMN()-1))," us"," ",1) how to find end line?
but I need to avoid finding us in the middle of a line (i.e) "give us a hand", so i need away to find "us"+CHAR(10). is it possible?

[JBeaucaire]

Maybe:

=SUBSTITUTE(INDIRECT(ADDRESS(ROW(),COLUMN()-1))," us"&CHAR(10)," ",1)

[ulao]

I figure that as-well, not sure the difference in + and & but it also didnt work.