End/Beginning of Cell Search/Replace?

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?
 
E

Eduardo

Hi,
To search and replace with excel press

CTRL + H

if this helps please click yes thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Way do do search/replace on beginning/end of cell w/o functions? 1
Search end/beginning of cell 2
Removal of redundant spaces 2
Can find " ^p " in number-bulleted text, can't replace it: why? 2
Finding a single word via find/replace wildcards 11
find and replace parens 2
End-of-Table-Column Character 2
Search and Replace 2

Top