Results 1 to 5 of 5

Thread: Excel text conversion formula question

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Apr 2017
    Posts
    2
    Rep Power
    0

    Excel text conversion formula question

    Hi All! I own a business and find myself facing a VERY critical project that needs to get done ASAP! Basically I have a column in excel (2016 version) that reads State Names, and Territory Names that need to be converted into State/ Territory Abbreviations.

    Example:

    Column A Column B
    Arizona, Michigan > I need to read: AZ, MI
    U.S. Northeast > I need to read: NJ, NY, PA

    How can I write a function or use an add-in (assuming these are correct to consider?) to make this conversion possible!? It's really critical to get this correct so my business can continue to grow! I will really appreciate your input and advice on this matter!

  2. #2
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    12
    a VERY critical project that needs to get done ASAP
    In that case: hire a software firm,.

  3. #3
    Junior Member
    Join Date
    Apr 2017
    Posts
    2
    Rep Power
    0
    Quote Originally Posted by snb View Post
    In that case: hire a software firm,.
    I can manage most of the project- I am just reaching the bottleneck for converting this one text column. Seems there should be a fairly simple process for performing this?

  4. #4
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    12
    If it's urgent, if it's crucial don't rely on a forum of volunteers: act professionally.

  5. #5
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,270
    Rep Power
    10
    Hi Spencerb819,
    Welcome to ExcelFox
    Another point: In a Forum like this some of the people who help , like me, are not necessarily familiar with the various formats of the State/ Territory Abbreviations.
    It might be quite easy to achieve what you want , I do not know because I do not have access to the relevant information. If I googled for a few hours I might find for example , a table listing all the state abbreviations.
    To help get help , the thing would be to do the following:
    Get some sample data together. ( Desensitize it, - make it up if you like ).
    Restrict it to maybe about 40 rows. But try to pick data that tests as many typical scenarios as possible.
    Give us a Before , and an After. The After should look just as you want a Formula or code to give you based on the data in the Before . Don't use a Image screenshot, other than to support the data you give us in another way. That other way is probably in this Forum through uploading a Workbook. ( You could also try the Tools indicated below in my signature, - they produce a screen shot in the Post which we can copy to a spreadsheet. )
    And see if you can find a definitive list somewhere in the internet of all the List of U.S. state abbreviations.. .. the first thing I googled .. https://en.wikipedia.org/wiki/List_o..._abbreviations ... you could copy from .. but I expect you can find a better one if you look around...

    On the face of it , it doesn't sound like it should be too difficult.

    Alan
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!

Similar Threads

  1. Replies: 3
    Last Post: 04-03-2014, 01:51 PM
  2. Conversion Of Data In Column To One Cell
    By macak in forum Excel Help
    Replies: 6
    Last Post: 08-19-2013, 01:40 PM
  3. Replies: 10
    Last Post: 12-10-2012, 11:28 PM
  4. Excel Formula To Extract Values From Text
    By Howardc in forum Excel Help
    Replies: 1
    Last Post: 08-22-2012, 09:05 PM
  5. Complicate Excel question?
    By Wilhelm Sorban in forum Excel Help
    Replies: 2
    Last Post: 07-21-2012, 05:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •