Concatenate

  • Thread starter Thread starter Mike G
  • Start date Start date
M

Mike G

I want to join two columns of data into one. The first
column has this data: 18000. The second column has data
similar to this but of varying values like this: 00566. I
want the product to appear like this: 1800000566 but I get
18000566 because it lops off the two leading zeros. How
can I get around this?
 
Look for a message by Meaux called "leading zeros" which has solution(s) in
it. It's from 11/5/03.
 
Back
Top