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

Maybe you have trailing spaces in A1 or leading spaces in B1 or both?????

Jo wrote:

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

--

Dave Peterson

Your data in A1 may have space at the end of it.

--

"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

On Aug 8, 1:36 pm, "PCLIVE" wrote:
Your data in A1 may have space at the end of it.

--

"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- Hide quoted text -

- Show quoted text -

But I re-copied it and did paste special as value but still have the
problem! How can I go around this?

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

check = len(A1)
and B1 and C1 you will probably see a higher number than expected
you might try
=concatinate(trim(clean(A1)),...)
if there is a large discrepency in the length
note these won't get rid of all possible charaters but will most common ones.

"Jo" wrote:

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

On Aug 8, 1:55 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
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- Hide quoted text -

- Show quoted text -

Thanks David, it worked.....