Need to to see true value result of a Concatenated cell

[skyport]

I have 4 cells (A1-A4) that concatenate into a fifth cell (A5). How can I have the result in A5 show in the formula window of A6 as the actual result instead of the concatenate formula as it does in A5?

 

[sheetspread]

the F9 key will show the cell contents in the bar

 

[FDibbins]

If you mean, you want to clock on A5 - where that formula is - and have the formula bar show the answer instead of the formula? why< you can see the answer in the A5...if you change what displays in the formula bar, the formula is gone (if you enter)

If you just want to temporarily see the answer, click on the celll, press F2 (edit), then F9 (calc). As I said though, if you now hit ENTER instead of ESCAPE, that formula is gone

 

[skyport]

what I was hoping to do is have separate column that would show the real result of the concatenated data and not the formula in both the cell and formula bar

 

[sheetspread]

It sounds like the cell is formatted as text. You should be seeing a result in the cell, not the formula preceded by an = sign. Change the format to general or number, and double click (or press F2) and enter again. If that still doesn't work you can recalculate the cells in bulk with a VBA line.

 

[FDibbins]

what I was hoping to do is have separate column that would show the real result of the concatenated data and not the formula in both the cell and formula bar

The only way to do that would be to copy/paste values from the cell containing the formula. This could be done manually or with VBA. You cannot have a cell that contains the answer without the formula, unless you actually put the answer there

 

[skyport]

Hi Guys. thanks for the clarification and help. I will proceed accordingly. I appreciate the input from both of you.