#1   Report Post  
Old December 15th 05, 12:30 AM posted to microsoft.public.excel.worksheet.functions
blakrapter
 
Posts: n/a
Default Find and Replace


Is there a way to use the "find and replace" function to find and delete
words? I have a spreadsheet that has a column of cells with product
descriptions in them. Each description contains the manufacturer's
name, which I don't need. I did a find and replace of the of
manufacturer name and didn't put anything in the replace with box, but
it didn't do anything. Is it possible to find and delete? I could do
it with a space, but I would rather not.

Thanks


--
blakrapter
------------------------------------------------------------------------
blakrapter's Profile: http://www.excelforum.com/member.php...o&userid=28926
View this thread: http://www.excelforum.com/showthread...hreadid=493641


  #2   Report Post  
Old December 15th 05, 01:03 AM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default Find and Replace

Perhaps you had "Match entire cell contents" checked under
EditReplaceOptions.

Uncheck and try again with nothing in the Replace With: box


Gord Dibben Excel MVP

On Wed, 14 Dec 2005 17:30:37 -0600, blakrapter
wrote:


Is there a way to use the "find and replace" function to find and delete
words? I have a spreadsheet that has a column of cells with product
descriptions in them. Each description contains the manufacturer's
name, which I don't need. I did a find and replace of the of
manufacturer name and didn't put anything in the replace with box, but
it didn't do anything. Is it possible to find and delete? I could do
it with a space, but I would rather not.

Thanks

  #3   Report Post  
Old December 15th 05, 01:24 AM posted to microsoft.public.excel.worksheet.functions
Roland
 
Posts: n/a
Default Find and Replace

Finding and replacing with nothing works for me.

Maybe you had a range selected other than the range that you intended to
perform the operation on.



"blakrapter" wrote:


Is there a way to use the "find and replace" function to find and delete
words? I have a spreadsheet that has a column of cells with product
descriptions in them. Each description contains the manufacturer's
name, which I don't need. I did a find and replace of the of
manufacturer name and didn't put anything in the replace with box, but
it didn't do anything. Is it possible to find and delete? I could do
it with a space, but I would rather not.

Thanks


--
blakrapter
------------------------------------------------------------------------
blakrapter's Profile: http://www.excelforum.com/member.php...o&userid=28926
View this thread: http://www.excelforum.com/showthread...hreadid=493641


  #4   Report Post  
Old December 15th 05, 01:25 AM posted to microsoft.public.excel.worksheet.functions
Roland
 
Posts: n/a
Default Find and Replace



"blakrapter" wrote:


Is there a way to use the "find and replace" function to find and delete
words? I have a spreadsheet that has a column of cells with product
descriptions in them. Each description contains the manufacturer's
name, which I don't need. I did a find and replace of the of
manufacturer name and didn't put anything in the replace with box, but
it didn't do anything. Is it possible to find and delete? I could do
it with a space, but I would rather not.

Thanks


--
blakrapter
------------------------------------------------------------------------
blakrapter's Profile: http://www.excelforum.com/member.php...o&userid=28926
View this thread: http://www.excelforum.com/showthread...hreadid=493641




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace koba Excel Discussion (Misc queries) 1 November 23rd 05 11:19 PM
find and replace, within workbook Matt Carter Excel Discussion (Misc queries) 1 November 22nd 05 01:55 AM
Find & Replace in VB macro JackC Excel Discussion (Misc queries) 1 August 24th 05 09:22 PM
Find and replace of word causes change of font formatting jwa90010 New Users to Excel 4 July 22nd 05 08:10 PM
VB Find and Replace Bony_Pony Excel Worksheet Functions 10 December 6th 04 06:45 PM


All times are GMT +1. The time now is 06:39 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017