Change text entry to sort accurately
Jim, at present the text I want to change is in Col B. If I insert a helper
column to the right of it, and put your formula in it, will new text appear
in place of the old, or should I insert a second helper column to display the
new data?
"Jim Thomlinson" wrote:
Try this formula...
=A1 & REPT("0", 6-LEN(A1))
where your data is in cell a1
--
HTH...
Jim Thomlinson
"Alice M." wrote:
My column: Would like:
08-10 08-010
08-100 08-100
07-90 07-090
07-888 07-888
How do I add another 0 to change 08-10 to 08-010?
|