End/Beginning of Cell Search/Replace?

  • Thread starter Thread starter msnyc07
  • Start date Start date
M

msnyc07

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
 
Back
Top