SOLVED

Zip+4 not showing the dash

Copper Contributor

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!

4 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@jackiebiggs 

That 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

Thanks Sergei. I will try what you suggested.
Thanks so much Sergie. It worked!

@jackiebiggs , you are welcome, glad it helped

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@jackiebiggs 

That 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

View solution in original post