CONCATENATE I have two text strings in cells but it wont work

[paintsr]

Cell ab WSDA-LaGasa-018
cell ac Legs removed for Barcode Project Jan09
When put in the formula by typeing no luck if I manually click on the fields
it works sometimes. =CONCATENATE(AB2,AC2) is the formula....Seems like it
does not want to actually calculate.

 

[Pete_UK]

I think that cell might be formatted as Text - change the format to
General, click on F2 then <Enter>.

Or, it might be that your calculation mode has been set to Manual.
Click on Tools | Options | Calculation tab and ensure that this is set
to Automatic.

An alternative way of writing your formula is this:

=AB2&" "&AC2

which puts a space between the two strings.

Hope this helps.

Pete