Windows Forum

Ask something
Discussion Locked

Excel Formula for correcting all caps

0 helpful
5 replies

by nsohenick 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am converting information that was exported to excel. The information that was entered by a user was in all caps. We are merging all contact info from Outook into a general contact list. I need to fix all if his feilds to show caps in the first letter and lowercase for the rest. I know I can use text to columns to break where the caps begin, but I am having trouble with the formula. Has anyone tried this before? My brain is in slow mo since maternity leave.

Thanks,

Nicole

5 replies

by dklippert

Here's the formula to be entered in an empty column.
(substitute the target cell for A1)

=Proper(A1)

by don christner

Hey Nicole,

It's probably the lack of sleep! Suppose the text you want to convert is in cell A1. The formula would be:

=left(A1,1)&lower(mid(a1,2,50))

This takes the left most character of A1 as is and adds everything from the second tothe 50th character in lower case.

Get some sleep,
Don

by nsohenick

I tried the first way that I saw. I was very simple. Oh, and the best rest I get is when I am at work....

Thanks,

Nicole

This discussion is closed to new replies.