Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mr: beba
 
Posts: n/a
Default can i register a digit in excell sheet cell

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



  #2   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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
a problem with pasting into Excell sheet Jurek Setting up and Configuration of Excel 1 March 17th 05 06:54 PM
spread the number 123.45 so each digit goes to a different cell Linda H. Excel Worksheet Functions 6 February 17th 05 07:07 PM
Sheet Names and Cell References Reed Excel Worksheet Functions 1 January 19th 05 10:17 PM
Cell Colors and Sheet Protection cincode5 Excel Discussion (Misc queries) 1 December 3rd 04 10:39 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"