Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Need formula help for MS Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 20-04-2012
Member
 
Join Date: Apr 2012
Posts: 1
Need formula help for MS Excel

Good afternoon! I've scoured the internet for a while, but I just can't seem to find (or perhaps understand) quite what I'm looking for....

I receive a spreadsheet every morning of 200+ addresses. I need to find a way to replace state abbreviations (listed in their own cells) with their corresponding time-zone in order to effectively sort the list.

I work in a call center and its imperative to get eastern calls out first as we have a limited time frame.

Anyone have any ideas on how to get this to work? I've tried utilizing the IF, SUBSTITUE, or REPLACE formulas, I'm just beginning to learn formulas and I couldn't get them set up properly (assuming any of them are actually what I need)


Thanks in advance!

Reply With Quote
  #2  
Old 08-05-2012
Member
 
Join Date: Jun 2011
Posts: 632
Re: Need formula help for MS Excel

The most easiest way to do that is by using Find and Replace. It is activated by pressing Ctrl + F. It is common that in your address list you will be having many addresses of a common start. For Example NY, so if the timezone is UTC-8, then simply hit Ctrl + F and then click on Replace. In Find type NY and in Replace type UTC-8. Click on Replace all. You will need to do this for each and every State. One of the best way to do is this is by using a Macro. You can record a Macro of this process and then click on it to replace everything automatically.

There is one more option you can use. There is as tool for Excel called as FindandReplace Tool. This tool comes with 30 days trial and best recommend to replace multi text in excel. But you have to save your files in .xls format. That is Office 97-2003 format. Not xlsx. Download and try this too.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Need formula help for MS Excel"
Thread Thread Starter Forum Replies Last Post
excel 2010 formula mr.dale Windows Software 3 06-03-2011 10:47 PM
Excel Formula Scott2580 MS Office Support 2 15-02-2011 02:21 PM
Excel formula Me Me Taylor Windows Software 2 06-04-2009 05:11 PM
Formula help in excel 2007 Muhammad Waqar Windows Software 1 24-11-2008 07:29 PM
Need help in excel formula Landon Software Development 2 27-10-2008 04:28 PM


All times are GMT +5.5. The time now is 06:58 AM.