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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
="group"&TEXT(LEFT(E5,2),"00")
or if E5 has only a number value
="group"&TEXT(E5,"00")
best wishes
 
Back
Top