End/Beginning of Cell Search/Replace?

I find myself having to export data to word so I can do simple find/replace
which I'd do in Word with ^p such as

Find
^p(space key)
Replace
^p
(removes leading spaces)

Find
s^p
Replace
^p
(removes trailing s i.e. plurals)

Is there anyway to do this with Excel S/R that is indicate beginning/end of
cell?

Hi,
To search and replace with excel press

CTRL + H

if this helps please click yes thanks

"msnyc07" wrote:

I find myself having to export data to word so I can do simple find/replace
which I'd do in Word with ^p such as

Find
^p(space key)
Replace
^p
(removes leading spaces)

Find
s^p
Replace
^p
(removes trailing s i.e. plurals)

Is there anyway to do this with Excel S/R that is indicate beginning/end of
cell?