| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling partial information from a cell
Hi,
Thanks to Dave and Peo for help on my previous request. I have a list of 5 digit zip codes (eg. 90210) and a list of 5 + 4 digit zip codes (eg. 90210-1234). How can I pull just the first 5 digits from the 5 + 4 digit zip codes? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pulling partial information from a cell
=LEFT(A1,5)
"Emeryville John" wrote: Hi, Thanks to Dave and Peo for help on my previous request. I have a list of 5 digit zip codes (eg. 90210) and a list of 5 + 4 digit zip codes (eg. 90210-1234). How can I pull just the first 5 digits from the 5 + 4 digit zip codes? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pulling partial information from a cell
With
A1 containing a numeric zip code, formatted as either a 5-digit zip code OR a 5+4 zip code This formula returns the 5 digit part: B1: =LEFT(TEXT(A1,"00000"&IF(A1=10000,"-0000","")),5) Is that something you can work with? Regards, Ron Coderre Microsoft MVP (Excel) "Emeryville John" wrote in message ... Hi, Thanks to Dave and Peo for help on my previous request. I have a list of 5 digit zip codes (eg. 90210) and a list of 5 + 4 digit zip codes (eg. 90210-1234). How can I pull just the first 5 digits from the 5 + 4 digit zip codes? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling cell information from one workbook to another | Excel Worksheet Functions | |||
| Deleting partial information from all cells in a column | Excel Worksheet Functions | |||
| Formula for Pulling partial data from one cell into another | Excel Worksheet Functions | |||
| Pulling cell information from one sheet to another in same databas | Excel Discussion (Misc queries) | |||
| Pulling parts of information from one cell and putting in another | Excel Discussion (Misc queries) | |||
Hybrid Mode
