How to concatenate?

[AS]

I have two fields I want to combine into one. Column A and Column B. Column
A is a Business Name, Column B is an Account Number. For example: Jones
Supply and 2964. I want this to read Jones Supply 2964 for the purpose of a
mailing list. Must have at least 1 space between name and number. I have
tried the following:

1. Inserting a blank Column C to hold the formula.
2. Using various combinations in the C column such as
=A1&" "&B1
=CONCATENATE(A1,B1)

All that I end up with is the formula in Column C, not the combined fields.
I have done this successfully once before, but I cannot remember how. What
am I doing wrong?

Please help! Thanks.

 

[Frank Kabel]

Hi
1. check that your column is not formated as 'Text'. change the format
to 'General' and re-enter your formula
2. If 1. does not work goto 'Tools - Options - View' and make sure
'Formulas' is NOT checked

 

[AS]

Must have been the column format. Thanks so much!