Can any one help me to get acronym in excel
Ex: Hewlett Packard Global Soft Pvt Ltd = H P G S
Thanks in advance
Can any one help me to get acronym in excel
Ex: Hewlett Packard Global Soft Pvt Ltd = H P G S
Thanks in advance
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks