Format cell with text and number

December 2016


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

Related :

This document entitled « Format cell with text and number » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.