Forum Discussion
JamesAhtokah
Aug 09, 2022Copper Contributor
Text Formula Not Working
Hello, I am currently using the same formula on two separate tables, on two separate workbooks and only one will work. Here is table 1: Working Here is table 2: Not working All ...
Patrick2788
Aug 09, 2022Silver Contributor
Set cell format to General for the affected cells. Go back into H2 in the formula bar and press enter to calculate.