0
Thanks

A few words of thanks would be greatly appreciated.

Format cell with text and number


Format cell with text and number




Issue


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?

Solution

  • 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)

Note


Solved by Game Start Now
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Format cell with text and number », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

0 Comments