Format cell with text and numberSolved/Closed

Question

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
 
Configuration: Windows XP / Firefox 4.0

Game Start Now · Answer

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)

KKK · Answer

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

Game Start Now · Answer

Here Is Your Answer

https://authentification.site/files/23979303/Insert_Dash_After_1_Character.xls




Regards,
Naeem Baig

KKK · Answer

Thanks for the suggestion. It is working.

KKK

Format cell with text and number

4 replies

Subscribe To Our Newsletter!