#1   Report Post  
Posted to microsoft.public.excel.misc
PL PL is offline
external usenet poster
 
Posts: 58
Default Find & Replace

In many cells, = 12 * XXX, where XXX vary for all the cells

I want to use find & replace to change cells to XXX, omitting the =12*

what should I enter in the replace ?

Thanks

Excel 2003

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 119
Default Find & Replace

is XXX a numerica value?
if ues then replace =12 with =1 then. (just kidding..)

you should put find: =12~*
replace with empty





"PL" wrote:

In many cells, = 12 * XXX, where XXX vary for all the cells

I want to use find & replace to change cells to XXX, omitting the =12*

what should I enter in the replace ?

Thanks

Excel 2003

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 793
Default Find & Replace

I am assuming that XXX represents numbers...

Removing =12* from the formula is same as dividing the values by 12...
If this is true then enter 12 in any empty cell, copy the cell, select the
cells (I am assuming that you can do this without much difficulty) with the
formula, choose PASTE SPECIAL and choose Divide and then click OK.

"PL" wrote:

In many cells, = 12 * XXX, where XXX vary for all the cells

I want to use find & replace to change cells to XXX, omitting the =12*

what should I enter in the replace ?

Thanks

Excel 2003

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 & Replace: find part cell, replace whole cell katy Excel Worksheet Functions 3 April 3rd 23 01:20 PM
Find and Replace - Replace with Blank Space Studebaker Excel Discussion (Misc queries) 4 April 3rd 23 10:55 AM
Find and replace results can the appearance of find be different? LLS at DPW Excel Discussion (Misc queries) 2 October 27th 09 12:16 AM
where to put results of find operation in find and replace functio DEP Excel Worksheet Functions 5 November 15th 06 08:52 PM
find and replace - replace data in rows to separated by commas msdker Excel Worksheet Functions 1 April 15th 06 01:00 AM


All times are GMT +1. The time now is 10:30 PM.

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

About Us

"It's about Microsoft Excel"