Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
a problem with pasting into Excell sheet | Setting up and Configuration of Excel | |||
spread the number 123.45 so each digit goes to a different cell | Excel Worksheet Functions | |||
Sheet Names and Cell References | Excel Worksheet Functions | |||
Cell Colors and Sheet Protection | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |