Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate help
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate help
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" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate help
Thanks so much for the assistance! It worked!
"JLatham" wrote: 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" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate help
Glad something I suggested actually worked right the first time!
Happy to have been able to help, and thanks for the feedback. "Gary S" wrote: Thanks so much for the assistance! It worked! "JLatham" wrote: 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate | Excel Worksheet Functions | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
concatenate | Excel Worksheet Functions | |||
Un - Concatenate? | Excel Worksheet Functions | |||
Un-concatenate | Excel Discussion (Misc queries) |