I am using the & function in a cell to present a value from three different cells. Here is my code:
='AMC Calculator'!E8&'AMC Calculator'K8&'AMC Calculator'!O8
The code works well as it properly shows values from each cell (e.g., '0 5 0'). However, I will only ever need one value from the three chosen cells as the other 2 cells will always be a 0. Thus, I would like to have the 0s not show up (e.g., '5' instead of '0 5 0'). I have already unchecked the "Show a zero in cells that have a zero value" from the "Display options for this worksheet" in the excel options menu. Any help will be greatly appreciated.
='AMC Calculator'!E8&'AMC Calculator'K8&'AMC Calculator'!O8
The code works well as it properly shows values from each cell (e.g., '0 5 0'). However, I will only ever need one value from the three chosen cells as the other 2 cells will always be a 0. Thus, I would like to have the 0s not show up (e.g., '5' instead of '0 5 0'). I have already unchecked the "Show a zero in cells that have a zero value" from the "Display options for this worksheet" in the excel options menu. Any help will be greatly appreciated.
