Proper text in excel

Trini · #1 (**permalink**) 07-17-07, 09:12

How can you convert text string to captialize the first letter of a sentence after a period also?

gvee · #2 (**permalink**) 07-17-07, 11:22

I wrote this uickl - it works but it feels a bit to convoluted.
It capitalises the first letter of the cell A1

Code:

=CONCATENATE(UPPER(LEFT(A1,1)),LOWER(RIGHT(A1,LEN(A1)-1)))

norie · #3 (**permalink**) 07-17-07, 14:09

Why not use the PROPER worksheet function?

gvee · #4 (**permalink**) 07-17-07, 14:37

Because I didn't know it existed

I told you it was pretty convoluted

MikeTheBike · #5 (**permalink**) 07-18-07, 07:50

Hi

I though the PROPER function capitalises ALL words, doesn't it?

MTB

gvee · #6 (**permalink**) 07-18-07, 08:27

You are indeed correct Mike!
I think what the user wants is to capitalise the first word in every sentence (hence theextra bit about after a full stop!).
I can only think of another convuleted way of doing this which is very inefective - so I don't want to post it.
Hopefully someone will come up with a better idea

norie · #7 (**permalink**) 07-18-07, 14:15

I think youll find that PROPER does that.

gvee · #8 (**permalink**) 07-18-07, 16:38

I beg to differ;

Code:

a b c d e f		A B C D E F
abcdef			Abcdef
abc def			Abc Def
ab. cde. F		Ab. Cde. F

It capitalises the first letter of every word.

Internet Services

Web Development

Digital Marketing

Consumer Tech