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 ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Mr: beba" <Mr:
wrote in message
...
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