Aug 23 2021 02:26 PM
hello. I combined two columns using the =CONCAT function. The two columns were zip code and then the Plus 4 digits. I then highlighted the new column to change it to the Special Text Zip+4. However, the dash does not show unless I go into each cell and then click Enter. There are too many rows to do this manually. Is there a shortcut to do this? I attached a screenshot of what it looks like. as of now. I did try to create a Macro, which I have never used before, but that didn't work for me (probably because I don't know what I'm doing.
Thanks in advance!
Aug 23 2021 02:43 PM
SolutionThat since CONCAT() returns text, not number, and you shall re-enter after changing the type.
You may change formula on O1 from =CONCAT(A1,B1) on =CONCAT(A1,B1)+0
Apply ZIP+4 format to column O, select entire range (e.g. O1:O1000) and Ctrl+D.
Alternatively use texts like =A1 & "-" & B1
Aug 23 2021 02:43 PM
SolutionThat since CONCAT() returns text, not number, and you shall re-enter after changing the type.
You may change formula on O1 from =CONCAT(A1,B1) on =CONCAT(A1,B1)+0
Apply ZIP+4 format to column O, select entire range (e.g. O1:O1000) and Ctrl+D.
Alternatively use texts like =A1 & "-" & B1