The problem is probably that either A1 or B1 has a lot of space characters
in it. See what =LEN(A1) and =LEN(TRIM(A1)) say, and equivalently for B1.
You may also have non-printing characters, so try CLEAN instead of TRIM.
--
David Biddulph

"Jo" wrote in message
ups.com...
I am using CONCATENATE function to merge a1-b1-c1 cells.

Althoug it works fine the resulting cell has a huge SPACE between a1
and b1 although I couldn't know whay?

What could be the problem?

Thanks,
Jo