find and replace text

F

fitz

I want to delete part of the text in several cells. When I use the find and replace tool it deletes all the text in that cell rather than just the one word I want deleted

How do I delete just the one word in a cell

Or even just replace the one word in a cell?
 
D

Dave R.

What is the text you want replaced, and what are some examples of the
contents the cells you want worked on?

Sounds strange that using find/replace will replace anything other than what
you ask it to replace..

If you want a function, you can use =SUBSTITUTE(A1,"replace this
phrase","with this")



fitz said:
I want to delete part of the text in several cells. When I use the find
Click to expand...
and replace tool it deletes all the text in that cell rather than just the
one word I want deleted.
 
R

Ron de Bruin

Edit > Replace

Look in the options
Maybe you have Match entire cell contents checked



--
Regards Ron de Bruin
http://www.rondebruin.nl


fitz said:
I want to delete part of the text in several cells. When I use the find and replace tool it deletes all the text in that cell
Click to expand...
rather than just the one word I want deleted.
 
F

fitz

Now the find and replace is working for a single word - was not doing that before. .

But now I want to replace only part of a word. I want to remove the

/1200

in the text below

graphics/r1200c/ztechnik/z4010.jp

I have tried using wildcards for the find and replace: */1200c* and still the entire line is deleted

Any suggestions on removing the text I indicated?
 
D

Dave R.

It would be clearer if you showed what you wanted that line to look like
when you were done, but this:


replace
/?1200c
with
/r

returns:

graphics/r/ztechnik/z4010.jpg

from
graphics/r1200c/ztechnik/z4010.jpg
 
Top