CONCATENATE and spacing problem

  • Thread starter Thread starter dramaking
  • Start date Start date
D

dramaking

Hi,

I have a quick question for your forum....
I have text in three columns ranging from A1 to C1 eg. James in (A1)
Mark (in B1) Smith (in C1).

I want to create a fourth column with all text in it wit
spaces...i.e., "James Mark Smith" (in D1)

However, using the concatenate function it returns text lik
"JamesMarkSmith"

can anyone help?

Thanks in advance.:confused
 
Hi

Try

=A1&" "&B1&" "&C1
or put the " " as extra fields in your CONCATENATE function

Andy.
 
This could result in too many spaces. Try

=Trim(trim(A1) & " " trim(a2)) & " " & trim(a3)
 
No need to trim each one seperately, especially when you've already wrapped
trim around the whole thing.

=TRIM(A1&" "&B1&" "&C1)
 
You learn something new every day.


Dave R. said:
No need to trim each one seperately, especially when you've already wrapped
trim around the whole thing.

=TRIM(A1&" "&B1&" "&C1)
Click to expand...
 
I had always assumed that TRIM worked the same in Excel as in FoxPro. Not
the case, it seems.

Dave R. said:
No need to trim each one seperately, especially when you've already wrapped
trim around the whole thing.

=TRIM(A1&" "&B1&" "&C1)
Click to expand...
 
Back
Top