wrote:

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?

This is the easy way: One word per cell and use the left() function.

Example :
A B C D
1 I am a boy

I have a French version of Excel
=MAJUSCULE(GAUCHE(A1;1)&GAUCHE(B1;1)&GAUCHE(C1;1)& GAUCHE(D1;1))

I suppose that in English it should be sommething like
=CAPITAL(LEFT(A1;1)&LEFT(B1;1)&LEFT(C1;1)&LEFT(D1; 1))

And it should work in any spreadsheet software.



--
Vie : n.f. maladie mortelle sexuellement transmissible
Benoit chez lui à leraillez.com