Abbreviations to full Words
Does anyone have a way of converting state abbreviations to the full state name? Example AZ to Arizona. I have two lists I need to sort by state and compare. One list has the abbreviation and the other the full name. Of course they don't sort the same.
I'm currently working on a spreadsheet that requires using lots abbreviations and codes, at the moment I have a comment on the column header with all the abbreviations and their meaning in but its proving difficult to handle as I add more to it.
Is there a way to have the relevant info displayed as I hover my cursor over the cell?
one example from the spreadsheet is using initials instead of full names. So when I move the cursor over the cell, the full name is show, in a similar way to how cell comments are shown, but only showing the relevant data.
maybe this action is not that difficult for savvy users.
I have a column containing the regular state abbreviations in a CSV document. I would like to create a formula to convert individual cells containing these abbreviations into grouped geographical regions for sales territories. Crudely thinking, run the formula on Col A and populate the result in Col B.
I am looking for a way to turn state names into abbreviations. Ex. Texas into
Our system just changed to a new way of presenting addresses. It screws up the label printing system as a result.
Please help me with the following formulas:
Change a column with full state names (Florida, California, Texas, etc) to their corresponding abbreviations (FL, CA, TX, etc.)
Related Applications & Scripts
A creative way to show your images and movies! Words & Images is a dynamic interactive full customizable image gallery, which you can use to create outstanding galleries, presentations or intros. Or just load it into your flash site to give more options and impact your user.
The movie clip generates an animated 3D space that you can interact with each word. When clicked, a word brings an image and customized text to the user.
All the data (words, images, colors, subtitles, sizes) are completely dynamic and XML driven. So you can update, add or delete words and texts editing only one XML file.
This is a simple effect to animate any of your words. You can use it as an introduction to your movie by just adding a Skip Intro button if you want. The actual size is around 3kb the remaining size is of the embed font.
+ Ajax like preloader on intro.
+ Add unlimited XML Slides & Links.
+ Full Screen Transparent Gradient.
+ Change the Background Color in the HTML !!!
+ XML Logo(.fla included or load a transparent .gif)
+ XML Footer
+ Screen Size Warning if screen is too small.
+ Set at 5 second delay, and easily changed in the .fla file. (instructions included)
+ Full Screen on Right Click.
+ Auto Play
+ Full featured Right Click Menu w/ email.
+ Awesome Hand Designed Tween XML Load animation.
Full screen scroll that resizes, with ease, depending on window size. It functions with mousewheel. If the content size smaller than stage, the scroll dissapear.
A Digital Clock and Full Date Calender displaying in 12 hr format Time with full date. Files Include: FLA, SWF, HTML and Font
Colours are easily changeable and Resizeable Complete in vector object. And can be easily add into your another flash project.