Concatenation
I have a situation where there are 6 colums with data in each row:
V, 02, BA,1,3,R
When I concatenate this, the result drops the 0 preceding the 2 and gives
the result V2BA13R when it should be V02BA13R. How do I do this?
I cannot change the 0 to a O as part of the process. It must remain as 0. I
attempted to find/replace the 0 with '0 to make it text but that didn't work
either.
Anyone have any ideas?
|