Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PICK UP FIRST CHARACTER OF WORD
In one column name of the companies are appearing but the lenght or number of
words in the name of company is unlimited. I would like to pick up first character of each word (first character after the space). e.g. if number of words in the name can consist of 25 words, in that case 25 first character should be picked. How to do that .... pl. help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PICK UP FIRST CHARACTER OF WORD
Difficult to do with native functions.
Here is a User Defined Function that works. Function acronym(mycell) temp = Left(mycell, 1) For j = 1 To Len(mycell) If Mid(mycell, j, 1) = " " Then mynext = Mid(mycell, j + 1, 1) temp = temp & mynext End If Next j acronym = UCase(temp) End Function Change last but one line to: acronym = temp if you do not want caps. Unsure of how to use a User Defined Function? see David McRitchie's site on "getting started" with VBA http://www.mvps.org/dmcritchie/excel/getstarted.htm best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Vijay Kotian" wrote in message ... In one column name of the companies are appearing but the lenght or number of words in the name of company is unlimited. I would like to pick up first character of each word (first character after the space). e.g. if number of words in the name can consist of 25 words, in that case 25 first character should be picked. How to do that .... pl. help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a Word Table from a Excel Macro | Excel Discussion (Misc queries) | |||
How can I paste 429 character Excel cell in MS Word ? | Excel Discussion (Misc queries) | |||
merging documents,exporting long landscape table to word with page breaks & numbers | Excel Discussion (Misc queries) | |||
Formula for Displaying the First Character of a word | Excel Discussion (Misc queries) | |||
Sending from excel to word template | Excel Discussion (Misc queries) |