I have different number of characters in cells of column D like below.
Variable Length rest567 7 test7890 8 variable12 10 temp12 6
Now, I want to populate values in column E against these cell values as the length of cells must be 10 if it is not prefix the required number of zeros as shown below.
Variable Length 000rest567 10 00test7890 10 variable12 10 0000temp12 10
How can we perform this in Excel?