Format cell with text and number

May 2017


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


Published by aakai1056. Latest update on August 27, 2010 at 02:12 AM by aakai1056.
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).