G

#### Guest

value. For example, in column A, I have the value 123 and in column B, I

have the value 456. In column C, I concatenate A & B into the text 123456.

I run into a problem when the three digit values in columns A and B contain

leading zeros, such as 031, 002, 067, etc. How do I combine or concatenate

the two, three-digit values into one, six-digit value when one or both of the

three-digit values contain leading zeros?