Wanted to show formula result, not formula. How???

  • Thread starter Thread starter Jenny
  • Start date Start date
J

Jenny

Hi,
I have following data in a excel sheet:

MidPref MidNum
0A 2345
0B 3456
0C 4567
I wanted to combine these two column charaters into one
singe column, such as the following:
MidPref MidNum MidCombine
0A 2345 0A2345
0B 3456 0B3456
0C 4567 0C4567
I used the CONCATENATE function in the excel sheet, but
my problem is on the result column "MidCombine", It
didn't show the result that I wanted, but only show the
function like this: =CONCATENATE(A2,B2)
Can anyone tell me what is wrong with this? or how can I
show the combined column results not the formula?
Thanks for any help.
Jenny
 
Thank you, Peter.

But I tried that way, the problem is still there. Is
there any other thing that I did wrong?
Thanks,
Jenny
 
Jenny-

Format the "MidCombine" column to "General". Enter the formula and then
copy down.
 
Back
Top