Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Global find and replace in Excel 2007

I want to replace the last 2 digits of a series of cells that contain an 8
digit number and other text. The number is 18081800 and I want to make the
last 2 digits 01 instead of 00. When I use wildcards, it replaces the whole
number with the wildcards as well as 01. What am I doing wrong and can you
give me an example of the right wat to do this. Here is what I did:

Find what: 180*00

Replace with: 180*01

It replaces 18081800 with 180*01. Why?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Global find and replace in Excel 2007

Are you trying to add 1 to the existing value in that cell--or are you trying to
replace the last two digits of any number with 01?

If it's the first, you can:
Select an empty cell
type 1 into that cell
Edit|copy (or its equivalent in xl2007)

Select the range to adjust
Edit|paste special|values and add
(or its equivalent in xl2007)

And then clean up that cell with the 1 in it.

If it's the second, you could use a formula...

Woodman wrote:

I want to replace the last 2 digits of a series of cells that contain an 8
digit number and other text. The number is 18081800 and I want to make the
last 2 digits 01 instead of 00. When I use wildcards, it replaces the whole
number with the wildcards as well as 01. What am I doing wrong and can you
give me an example of the right wat to do this. Here is what I did:

Find what: 180*00

Replace with: 180*01

It replaces 18081800 with 180*01. Why?


--

Dave Peterson
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 in Excel 2007 RM Excel Discussion (Misc queries) 3 July 3rd 08 12:20 AM
how do i find edit, replace in excel 2007 willyhoops.com Excel Discussion (Misc queries) 2 February 1st 07 03:45 PM
how do I do a global replace in all sheets in a workbook? knutknut Excel Worksheet Functions 3 June 26th 06 04:57 PM
how to do global replace in hyperlinks for entire excel document? AKennedy Excel Discussion (Misc queries) 2 March 19th 05 05:27 PM
GLOBAL search and replace Rebecca New Users to Excel 2 February 26th 05 01:30 AM


All times are GMT +1. The time now is 04:07 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"