I am trying to concatenate the text value of two cells into a third cell. I am trying to add the deptartment to an account code. So I have 22 in cell B2 and 58100 in cell B3. I want 2258100 in cell B1. I type in =B2&B3 in cell B1 expecting 2258100 but it shows =B2&B3 not the result of the formula. If I change the formula to a math formula it also just shows me the formula and not the results of the math. I have checked cell formats, they are good.
The list is exported from our new accounting system and I have also had this problem with Quick Books exported information too. I know how to do the concatenation part, I am wondering if anyone knows why it won't show me the value I want to see?
Thanks,
Greg
The list is exported from our new accounting system and I have also had this problem with Quick Books exported information too. I know how to do the concatenation part, I am wondering if anyone knows why it won't show me the value I want to see?
Thanks,
Greg