I need to remove the dash from a zip+4 field and possible put the
eight digits in new column.
I need to remove the dash from a zip+4 field and possible put the
eight digits in new column.
One would assume thatOriginally Posted by sigdig
=Left(A1,4)&Right(A1,4)
when placed in the cell that you want the eight digits in would do this.
---
Si fractum non sit, noli id reficere.
Sorry for the double post.
If I use the =Left(A1,4)&Right(A1,4), shouldn't the LEFT be 5?
The ZIP exp; 02771-1234 should the formula be =Left(A1,5)&Right(A1,4)?
Aaha - now we find the format of a zip - (it was omitted on your post, and the Zip+4 and 8 characters suggested a 4 character zip)Originally Posted by sigdig
Yes, adjust the Left-Right to suit, but that will give nine characters.
---
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks