Concatenation

  • Thread starter Thread starter Mike Gudyka
  • Start date Start date
M

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
 
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
 
Thanks for offering to help, but I think that I have a
problem with the application that was trying to read the
folmua.
 
Thanks for offering to help, but I think that I have a
problem with the application that was trying to read the
folmua.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with blank cells when concatenating 11
Concatenate with a specific number of spaces 3
Excel concatenation 2
Concatenation in Excel 2003 7
Concatenation help 4
concatenate in array formula? 1
How do I alphabetize & concatenate cells & maintain row integrity 1
CONCATENATE text to create a formula to be evaluated 2

Back
Top