LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling cell information from one workbook to another Quinci Excel Worksheet Functions 3 January 29th 08 02:12 PM
Deleting partial information from all cells in a column Smooney Excel Worksheet Functions 4 August 17th 07 02:11 AM
Formula for Pulling partial data from one cell into another Jamie Excel Worksheet Functions 5 June 1st 07 12:35 AM
Pulling cell information from one sheet to another in same databas Caramilk Excel Discussion (Misc queries) 2 May 12th 06 10:12 AM
Pulling parts of information from one cell and putting in another Mcobra41 Excel Discussion (Misc queries) 3 March 4th 05 07:01 PM


All times are GMT +1. The time now is 12:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"