Character Index

  • Thread starter Thread starter Kutty
  • Start date Start date
K

Kutty

1) I would like to know as follows :
- After I type
'a' in A1 colum
'b' in B1 colum
'c' in C1 colum

I will drag left to right as much as I need. Then the result
should be
a b c d e f g h and so on. I tried this a b c letters in three
colum and
dragged. But the result I get abc abc abc.
2) Another thing I need is :
Once I type in Colum A1 as '1' (in figure) need in colum B1 in
'one'
in word. Would appreciate your great service.
 
a, b, c, ... is not one of Excel's standard custom lists for AutoFill. You
will need to set the list up first under Tools -> Options and then it should
work.

See http://support.microsoft.com/kb/213360 for details on how to create a
custom function to solve your second question.

Andrea Jones
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index / Match / value in a range? 2
compare 2 columns and select the lowest 2
Date calculations 5
Connect a number to a picture bank and import that picture to exce 1
Drag and fill from other sheets 3
formula to count formatted result value 1
SUMIF by Week. 8
Hiding colums when saving as html 4

Back
Top