Format cell with text and number

Solved/Closed
KKK - Aug 25, 2010 at 10:55 PM
 KKK - Aug 26, 2010 at 10:30 PM
Hello,


I want to format certain cell into first letter "alpha" then dash (i.e "-") and then three digit number.
Example: A-001,
A-002
B-002
C-201
IF I AM ENTERING DATA INTO A CELL I WILL TYPE AS A001 THE RESULT SHOULD BE A-001 IN THE CELL.

CAN ANYBODY HELP ME IN THIS REGARD

kUMAR

4 replies

Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Aug 25, 2010 at 11:06 PM
This Thing Possible On Other Cell..... Not The Same Cell

If You Type A001 In Cell (A1) Then You Will Auto Get The Answer A-001 On Other Cell Where You Type The Formula....

Suppose You Have Typed A001 In Cell (A1)

You Have To Type The Formula On Cell (A2)
Here Is The Formula: =LEFT(A1,1)&"-"&RIGHT(A1,3)

Then You Will Get The Answer A-001 On Cell (A2)
0
Thanks for the reply, But I want to format the cell in a such a way while typing i ignore "-" the result should be in formatted type i.e A-002
0
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Aug 26, 2010 at 11:29 AM
0
Thanks for the suggestion. It is working.

KKK
0