View Single Post
  #1   Report Post  
Max
 
Posts: n/a
Default

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