Make the First letter Capital

[Yadlik]

This is probably a simple question, but I have searched the archives and cannot find the answer... How can I make the first letter of every work a capital letter?

Thanks for any help!

 

[Sektor]

Did you read second post of this thread?

 

[ballabooyeah]

Yes I did,

but this puts a capital on all words. I am looking to put this on the first word only.

Andrew

 

[Sektor]

Post example of what you have.

 

[ballabooyeah]

Ok here is some sample data.

the finished work is put on a post then embedded on a web page - here is the finished job - http://www.seahorseaquariums.com/store/content/49/New-Arrivals/
as you can see I have the capital's in lowercase but not the first letter

I can send this in XLS but can not see how to attached workbooks.

TETRA-RUMMY NOSE
Petitella georgiae
TETRA-RED PHANTOM
Megalamphodus sweglesi
TETRA-SERPAE MINOR LONG FIN
Hyhessobricon callistus
PACU-RED PIRANHA
Serrasalmus nattereri
ARCHER-FISH
Toxotes chatareus
DANIO-ZEBRA
Brachydanio rerio var
MINNOW-WHITE CLOUD
Tanichthys albonubes
MINNOW-WHITE CLOUD GOLDEN
Tanichthys albonubes
SHARK-SIAMESE FLYING FOX
Crossochelius siamensis
SHARK-SIAMESE FLYING FOX
Crossochelius siamensis
RASBORA-NAKED
Sawba resplenden
CICHLID-DUBOISI
Tropheus duboisi
SHRIMP-PINOKIO
Neocaridina sp

 

[Sektor]

A1 contains text.

=LEFT(TRIM(A1);1) & LOWER(RIGHT(TRIM(A1);LEN(TRIM(A1))-1))

 

[ballabooyeah]

Now I am going to sound stupid.

Where do I put this line of code in XLS?

I have the worksheet with it starting at A1. Is this a function ? I need some more help.

Andrew

 

[Sektor]

Yes, it's a function. Type it in cell B1 and fill down.

 

[ballabooyeah]

Still no Joy.

I ahve all my data in A1 to A26

in B1 I paste your code in does not work - shows it all as text

if I add a function whist on B1 it looks for LEN - then I get error.

Not sure what I am doing wrong here.

Andrew

 

[Sektor]

Example

 

[snoopyhr]

<>