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.

--
Regards

Roger Govier


"George B." wrote in message
...
Hello, Can I edit multiple cell's data all at same time?

What I have now:
A B C
1 ABC1 ABC8 ABC3
2 ABC7 ABC9 ABC2
3 ABC4 ABC6 ABC5

As you can see, all the cell's data starts with 'ABC' then various
numbers.
I want to be able to change every 'ABC' to 'ABZ' without disturbing the
numbers that are already in the cell. Right now for me to do this, I have
to
click on each cell and manually change ABC to ABZ. Can I do this somehow
by
being able to select cells from A1 to C3 and change only the 'C' and make
it
a 'Z' in all cells at the same time without disturbing the number that
follow
and the result looking like example below?

A B C
1 ABZ1 ABZ8 ABC3
2 ABZ7 ABZ9 ABZ2
3 ABZ4 ABZ6 ABZ5

I use excel 97

Thank you in advance for any advice someone may give.
George B.