How do i zero pad when using combination of text and numbers?

  • Thread starter kiran cherukumilli
  • Start date
K

kiran cherukumilli

i have a column of numbers.i want a combination of text and the column of
numbers in another column.Text being constant as "Group"
Reqd: groupxx where xx is the column of numbers
so for the combination, i type ="group"&LEFT(E5,2)
E being the column 5 being the row.
But i donot get the single digits zero padded.
for ex: i have 00,01,02,03...in the column of numbers and i get
group1,group2,group3 as result by apply above formula.
how do i get the zero padding?
 
B

Bernard Liengme

="group"&TEXT(LEFT(E5,2),"00")
or if E5 has only a number value
="group"&TEXT(E5,"00")
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating perfect combination of numbers to end up as close to 1700.0as possible 3
Adding a zero to the front of numbers 5
Count every group of numbers whose sum is zero & put number next toeach number 6
Excel 2007 charts: want to avoid zero values 1
Count every group of numbers whose sum is zero & put formula next toeach number 7
In Excel, when i key in 02352 and press enter, the zero goes off 1
Autosum mixed text and numbers returns zero 2
How to right-align text and numbers? 3

Top