Trouble Trimming and Concatenating

[chcalissie]

I have been using the same formulas, but this time they are not working. I wanted to make sure that the name fields are trimmed and then concatenate the last name, space, first name into a field for comparison. I've attached an example of the problem.

[Tony Valko]

The cells are formatted as text.

Change the format to General then re-enter the formulas.

[AlKey]

You can do it in one formula

=CONCATENATE(TRIM(B2)," ",TRIM(C2))

[Tony Valko]

you can do it in one formula

=concatenate(trim(b2)," ",trim(c2))

Here's another one...

=TRIM(B2)&" "&TRIM(C2)

[chcalissie]

The cell still shows the formula and not the result. I've attached the file again with the formula.

[Special-K]

Try

=TRIM(B2)&" "&(TRIM(C2))

[chcalissie]

No, just the formula shows in the cell instead of the names.

[Special-K]

Press Ctrl-'

[chcalissie]

I'm not sure what you mean. While I'm in the cell, press the CTRL and the single apostrophe key?

[chcalissie]

That doesn't work. It copies the title to that cell.

[AlKey]

That doesn't work. It copies the title to that cell.

Please see attached file

[martindwilson]

read post #2

[chcalissie]

I looked at your formula and entered it in my spreadsheet and the formula is still the only thing that shows. I tried to copy it from one spreadsheet to the other,but I wasn't sure what to select - like binary format, etc., so it only copied the name.

[martindwilson]

still the same? have you done what is said in post #2