| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert 9 digit zipcodes to 5 digits?
I have an EXCEL 2003 spreadsheet containing a column with zip codes in this
format: 12345-6789 How can I convert these zip codes to a column that just has the first five digits, that is: 12345 ? I will appreciate advice. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert 9 digit zipcodes to 5 digits?
In the new column use the formula =LEFT(A1,5)
"Robert Judge" wrote: I have an EXCEL 2003 spreadsheet containing a column with zip codes in this format: 12345-6789 How can I convert these zip codes to a column that just has the first five digits, that is: 12345 ? I will appreciate advice. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert 9 digit zipcodes to 5 digits?
=left(a1,5) will pull the first 5 characters from a cell.
************ Anne Troy VBA Project Manager www.OfficeArticles.com "Robert Judge" wrote in message ... I have an EXCEL 2003 spreadsheet containing a column with zip codes in this format: 12345-6789 How can I convert these zip codes to a column that just has the first five digits, that is: 12345 ? I will appreciate advice. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert 9 digit zipcodes to 5 digits?
DataText to Columns
De-limited by - Choose to not import(skip) the second column. Gord Dibben Excel MVP On Fri, 18 Nov 2005 08:17:09 -0800, Robert Judge wrote: I have an EXCEL 2003 spreadsheet containing a column with zip codes in this format: 12345-6789 How can I convert these zip codes to a column that just has the first five digits, that is: 12345 ? I will appreciate advice. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting the first 3 digits out of 6 digit cells? | Excel Worksheet Functions | |||
| Mod 10 & 11 | Excel Worksheet Functions | |||
| How do you display 16 digit numbers in excel ? (it keeps convert. | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| I have a col. with 6 digit nos to convert to 3 cols of 2 digits | Excel Discussion (Misc queries) | |||
Linear Mode
