# Format cell with text and number

Solved/Closed
Related:

- Format cell with text and number
- Format factory - Download - Other
- Excel date format dd.mm.yyyy - Guide
- Kingston format utility - Download - Storage
- Samsung format code - Guide
- Marksheet format in excel - Guide

## 4 responses

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

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)

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)

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
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7

Aug 26, 2010 at 11:29 AM

Aug 26, 2010 at 11:29 AM

Here Is Your Answer

https://authentification.site/files/23979303/Insert_Dash_After_1_Character.xls

Regards,

Naeem Baig

https://authentification.site/files/23979303/Insert_Dash_After_1_Character.xls

Regards,

Naeem Baig