+ Reply to Thread
Results 1 to 3 of 3

Acronym

  1. #1
    Registered User
    Join Date
    07-31-2009
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    15

    Acronym

    Can any one help me to get acronym in excel

    Ex: Hewlett Packard Global Soft Pvt Ltd = H P G S

    Thanks in advance

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,040

    Re: Acronym

    Hardly. Problem is here why for example it wouldn't take H P G S P L

    What's the rule that it don't take Pvt Ltd into acronym?
    Never use Merged Cells in Excel

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,040

    Re: Acronym

    Look this example and see problems:

    Book1.xls

    This is bunch of different types of acronyms.

    A is formula.
    B is propper acronym
    C is text
    (D:K) - select C column -> Text to Column -> Delimited -> Check Space box -> Finish

    Some match, some don't. See is this good enough for you.

    On other sheet (Sheet1) is explanation of all those acronyms taken from http://en.wikipedia.org/wiki/Acronym_and_initialism

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1