I have formated 2 Text columns to General and tried every which way to
merge the cells into one. A1 would be "Style" B1 would be "335B".
Cell C1 is formated as general. The formula in cell C1 is =A2&" "&B2.
No matter what I do it only displays the formula.
Tried the same exercise in a new sheet with the same value and it
works just fine.
Any ideas before I go and manually edit 3600 lines if data