Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

jim44314

macrumors newbie
Original poster
Apr 30, 2012
1
0
Concatenate function is not working. Function Builder indicates the result I am looking for but the cell containing the function is displaying the formula and not the result. I have formatted all of the effected cells as "General." The calculation preference is set at "Automatically."

Many thanks.
 
Concatenate function is not working. Function Builder indicates the result I am looking for but the cell containing the function is displaying the formula and not the result. I have formatted all of the effected cells as "General." The calculation preference is set at "Automatically."

Many thanks.
After you format the cell where the formula is to General, double-click in the cell to edit the formula, then press enter.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.