abbreviation

Need to be able to automate an abbreviation into a full name Ex: data in column reads” Rn”. Needs to spell out Registered Nurse in a separate column If another abbreviation is “abc”.. Spell out “ anything but cats” There would be about ten abbreviations I would need to program to automate...

Hello, I am trying to search a cell to see if it contains an abbreviation for job title.. if it contains the abbreviation, i want it to put in the full job title which is reference in another cell. I have got it working for one text cell by the following...

Hi I am using a vlookup formula but instead of displaying the result say "ABB" I'd like to return "ABBREVIATION" instead? Is it possible or do I need a different formula, index,match? Thanks Ian

Hello, In the attached file there are lists that recurring every 5 columns. Every first columns has > symbols. Firstly I neet to filtre all page by > symbol. Secondly every second columns has abbreviation name. I need to check there are abbreviation name in every second columns. After...

Hello, I have a file that I work on a weekly basis to upload item options, and these item options require abbreviations. These are limited to 15 Chars. So Items options are Alphanumeric, have symbols "/" "-" etc and I've been saving the abbreviations also alphanumeric. For example, some of...

Hello all. Working with an in-depth spreadsheet. I have one cell that contain CITY STATE ZIP and I canny split. I’m running a macro that will proper case my cells. However, on the cell with City State Zip - my state abbreviation goes from FL to Fl. Is there a macro I can run again to change the...

Hello. I have column H filled with state names in full. I would like to quickly change all state names into a 2 letter abbreviation. I'm assuming I can do a "VLOOKUP" formula? I do have a separate spreadsheet which has state names in column A and state abbreviation in column B. This is an...

Let's say I have a list of countries in my drop down list. Is it possible to spell them all out in the list but when one is selected, an abbreviated version appears in the cell? For example, if "United Kingdom" is in my list, when I select "United Kingdom", I want "UK" to appear in the active...

I am tracking travel expenses for employees. They receive an allowance each time they visit a given site but may not stay the whole day. Their site attendance record may show that they spent, say, 2.5 days on that site during a particular week but this equates to 3 travel allowances. The round...

I am building a Project Budget sheet and I am trying to shorten the formulas that provide sub-totals. I would be grateful if anyone could help. Staff names are represented in the first column followed by their day rate cost in the next. The subsequent columns represent weeks of the year. Each...