can i register a digit in excell sheet cell

M

Mr: beba

how i can register a digit in microsoft excell sheet.
example1
in column A i want register ( H) ,so now H will show all cell in A
column.as show in Fig1.

Fig1 column A
1 abc H
2 123 H
3 xyz H

i am using Office 2000 his product key is BT8PM-KHK3J-TQW3Y-944V4-VD9X3
 
M

Max

One guess as to what you're after ..
(Try on a *spare* copy of your sheet)

Assuming you have in A1:A3 :

abc
123
xyz

Put in B1: =A1&" H"
Copy B1 down to B3

You'll get in B1:B3 :

abc H
123 H
xyz H

You could then copy B1:B3
and do a paste special > values > ok
to overwrite the original values in A1:A3

Then delete col B ..
 
Top