View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] articulatedesigns@gmail.com is offline
external usenet poster
 
Posts: 1
Default Create Acronym (Extract first letter of each word)

On Wednesday, January 16, 2008 at 9:56:04 AM UTC-8, VB_Sam wrote:
How can I extract first letter of each word in Excel XP?

For example:
I am a boy
You are a girl

Using the pseudo-function called acronym(), the result will become:
IAAB
YAAG

I'm using Excel XP.
Is there any function which can do it?
If not, could anyone provide a macro for me?
(I'm only a beginner in macro)

Thanks.


Hi, Is there a way to create acronyms in Google Sheets?