Forum Discussion
Giant stupid numbers
My county assessor provided a CSV download of tax info; and one data field is a parcel number. Here is one 17-digit example: 366629301057000009 what I want to do is format it like this: 36-...
All I can come up with is this tedious formula:
=LEFT(A1,2)&"-"&MID(A1,3,2)&"-"&MID(A1,5,2)&"-"&MID(A1,7,3)&"-"&MID(A1,10,3)&"."&MID(A1,13,3)&"-"&RIGHT(A1,3)
=LEFT(A1,2)&"-"&MID(A1,3,2)&"-"&MID(A1,5,2)&"-"&MID(A1,7,3)&"-"&MID(A1,10,3)&"."&MID(A1,13,3)&"-"&RIGHT(A1,3)
This works great, and is not really tedious if I can make the solution work for about 1400 records in less than one minute!
Thanks very much for a solution as well as my introduction to a new formula methodology.
- You're welcome!
