corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Converting from capital letters to proper on Excel?


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Converting from capital letters to proper on Excel?
Rachel H
Member

Registered: 12th Nov 03
Location: Berks
User status: Offline
12th Apr 07 at 10:57   View User's Profile U2U Member Reply With Quote

My mind has gone blank, got 5 address lines that are all in capitals and need to convert them to only having capital letter on the first letter of each word.

What is the lookup/formula to do this?

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
how do u say OZ? Chris@Speedfreex General Chat 32 517
5th Mar 03 at 21:02
by corsametz
 
How do u remove semen stains from car seats? Steve General Chat 34 4077
14th Jun 03 at 23:48
by novaless18
 
MS Word Help Darren Geek Day 9 728
26th Feb 04 at 09:58
by Darren
 
Wicksteed park car show mattwhite East Midlands 12 338
17th Apr 05 at 09:34
by mattwhite
 
tigra saga mac1976 Scotland 2 221
19th Mar 07 at 22:14
by sri_davie
 

Corsa Sport » Message Board » Off Day » Geek Day » Converting from capital letters to proper on Excel? 28 database queries in 0.0112381 seconds