software

Hi everyone

I currently have a set of data which is all in upper-case text
characters.

Before I can merge the data with another column I need it so that the
first letter of each cell is in upper-case and the rest is in
lower-case.

e.g. I currently have LONDON and I need it to say London

Does anyone know if this is possible within Excel?

Many thanks for your help.

Jon--
fuzzyjon
------------------------------------------------------------------------
fuzzyjon's Profile: www.excelforum.com/member.php...oamp;userid=34378
View this thread: www.excelforum.com/showthread...hreadid=542110Hi fuzzyjon
This is one of the functions which you get with ASAP Utilities' free add-in,
along with tons of other useful stuff. Have a look he
www.asap-utilities.com

Hope this helps.
Andy.

quot;fuzzyjonquot; gt; wrote in
message ...
gt;
gt; Hi everyone
gt;
gt; I currently have a set of data which is all in upper-case text
gt; characters.
gt;
gt; Before I can merge the data with another column I need it so that the
gt; first letter of each cell is in upper-case and the rest is in
gt; lower-case.
gt;
gt; e.g. I currently have LONDON and I need it to say London
gt;
gt; Does anyone know if this is possible within Excel?
gt;
gt; Many thanks for your help.
gt;
gt; Jon
gt;
gt;
gt; --
gt; fuzzyjon
gt; ------------------------------------------------------------------------
gt; fuzzyjon's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34378
gt; View this thread: www.excelforum.com/showthread...hreadid=542110
gt;
If quot;LONDONquot; is in cell A1 the function =PROPER(A1) will give you quot;Londonquot;.

If it is quot;LONDON BRIDGEquot; you will get quot;London Bridgequot;.

Does this help?

--
Carlos

quot;fuzzyjonquot; gt; wrote in
message ...
gt;
gt; Hi everyone
gt;
gt; I currently have a set of data which is all in upper-case text
gt; characters.
gt;
gt; Before I can merge the data with another column I need it so that the
gt; first letter of each cell is in upper-case and the rest is in
gt; lower-case.
gt;
gt; e.g. I currently have LONDON and I need it to say London
gt;
gt; Does anyone know if this is possible within Excel?
gt;
gt; Many thanks for your help.
gt;
gt; Jon
gt;
gt;
gt; --
gt; fuzzyjon
gt; ------------------------------------------------------------------------
gt; fuzzyjon's Profile:
www.excelforum.com/member.php...oamp;userid=34378
gt; View this thread: www.excelforum.com/showthread...hreadid=542110
gt;

Hi Andy

Thanks for your help.

I have also just come across another way to do this too.... using the
PROPER() function.

Cheers
--
fuzzyjon
------------------------------------------------------------------------
fuzzyjon's Profile: www.excelforum.com/member.php...oamp;userid=34378
View this thread: www.excelforum.com/showthread...hreadid=542110Hi

It is worth checking out the add-in. It will do the job in place, rather
than using helper cells and there are lots of other interesting functions. I
have nothing to do with ASAP, by the way, I just like the add-in!!

Cheers - and glad you're sorted.
Andy.

quot;fuzzyjonquot; gt; wrote in
message ...
gt;
gt; Hi Andy
gt;
gt; Thanks for your help.
gt;
gt; I have also just come across another way to do this too.... using the
gt; PROPER() function.
gt;
gt; Cheers
gt;
gt;
gt;
gt; --
gt; fuzzyjon
gt; ------------------------------------------------------------------------
gt; fuzzyjon's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34378
gt; View this thread: www.excelforum.com/showthread...hreadid=542110
gt;