LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Gordon
 
Posts: n/a
Default

"Roger Govier" wrote in message

Hi George

One way would be to use Search and Replace
On your sheet, type Ctrl + h
In the white pane marked Find enter C
In the pane marked Replace type Z
Click replace all.



It might be better using "Find - ABC" and "Replace - ABZ" as there might be
other cells with "C" in that the OP doesn't want to replace with "Z"!


 
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
mass cell data editing George B. Excel Worksheet Functions 2 August 25th 05 08:23 AM
Counting Multiple Values In A Cell DiamondDean Excel Worksheet Functions 1 August 20th 05 07:22 AM
Validation - multiple criteria in one cell krd Excel Discussion (Misc queries) 0 August 17th 05 08:23 PM
Can multiple cell results be displayed in a single cell? FuadsCurse Excel Discussion (Misc queries) 2 May 18th 05 05:33 PM
editing multiple sheets at once blamires Excel Discussion (Misc queries) 1 January 5th 05 08:51 PM


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

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

About Us

"It's about Microsoft Excel"