I have the following formula: TEXT(RIGHT(E106,4),"0000")
It will return the first 4 characters in cell E106. I need to adjust that formula so that if cell E106 only has 3 charcacters or two or one then it will put zeros before those characters. Example:
If E106 = A10A56, the current formula will return A10A
If E106 = A10, the current formula will return A10 but I need it to return 0A10
If E106 = A1, the current formula will return A1 but I need it to return 00A1
etc.
Thanks.
err right() would give the other end of the string! dont you mean left() ?
TRY
=REPT("0",MAX(0,4-LEN(A1)))&LEFT(A1,4)
Last edited by martindwilson; 09-18-2014 at 05:41 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
sorry, yes, I meant left. I really do know my left from my right.Thanks for catching that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks