#1   Report Post  
Old January 5th 10, 03:23 AM posted to microsoft.public.excel.misc
PL PL is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
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  
Old January 5th 10, 03:33 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
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  
Old January 5th 10, 03:33 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
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 and replace results can the appearance of find be different? LLS at DPW Excel Discussion (Misc queries) 2 October 26th 09 11:16 PM
Find & Replace: find part cell, replace whole cell katy Excel Worksheet Functions 2 June 19th 08 01:39 PM
Find and Replace - Replace with Blank Space Studebaker Excel Discussion (Misc queries) 3 October 11th 07 11:39 PM
where to put results of find operation in find and replace functio DEP Excel Worksheet Functions 5 November 15th 06 07: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 11:10 AM.

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