Concatenate help

[Gary S]

Using the concatenate function, I combined 30 cells (text) into one cell. I
cannot seem to figure out how to get the resulting value. All I get is the
formula. Can anyone provide insight? Know this is basic but MS Help does
not seem to have the answer. Thanks....Gary

 

[JLatham]

That cell was probably formated as TEXT when you entered the formula, so the
formula is displayed instead of the resulting text. Select the cell again,
change the format to type General exit the format window ([OK]). With that
cell still chosen, press [F2] and then press the [Enter] key and you should
see the results, not the formula.

 

[Gary S]

Thanks so much for the assistance! It worked!

That cell was probably formated as TEXT when you entered the formula, so the
formula is displayed instead of the resulting text. Select the cell again,
change the format to type General exit the format window ([OK]). With that
cell still chosen, press [F2] and then press the [Enter] key and you should
see the results, not the formula.

Using the concatenate function, I combined 30 cells (text) into one cell. I
cannot seem to figure out how to get the resulting value. All I get is the
formula. Can anyone provide insight? Know this is basic but MS Help does
not seem to have the answer. Thanks....Gary

 

[JLatham]

Glad something I suggested actually worked right the first time!

Happy to have been able to help, and thanks for the feedback.

Thanks so much for the assistance! It worked!

That cell was probably formated as TEXT when you entered the formula, so the
formula is displayed instead of the resulting text. Select the cell again,
change the format to type General exit the format window ([OK]). With that
cell still chosen, press [F2] and then press the [Enter] key and you should
see the results, not the formula.

Using the concatenate function, I combined 30 cells (text) into one cell. I
cannot seem to figure out how to get the resulting value. All I get is the
formula. Can anyone provide insight? Know this is basic but MS Help does
not seem to have the answer. Thanks....Gary