Concatenation

[Mike Gudyka]

Dear ever so helpful News-Groupies:

I need to create a formula through concatenation that
contains a space. When I connect the six or seven cells
that I need to create the formula, it looks like it has a
space, but the formula doesn't work. When I backspace out
the space and then hit the space bar, the formula works
fine. I've tried putting the space at the end of a cell,
at the beginning of the next cell, or as its own cell. Is
there some strange way that the concatenate function
treats spaces? As always, much thanks in advance.

Mike Gudyka

 

[Frank Kabel]

Hi
you may post your formula which does not work

 

[JE McGimpsey]

It's really difficult to comment on a formula when you don't include the
formula. One example of the usage of CONCATENATE is

=CONCATENATE(A1," ",B1," ",C1)

or you could use the Concatenation operator instead:

=A1 & " " & B1 & " " & C1

 

[Guest]

Thanks for offering to help, but I think that I have a
problem with the application that was trying to read the
folmua.

 

[Guest]

Thanks for offering to help, but I think that I have a
problem with the application that was trying to read the
folmua.