corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

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 11:06   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?
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
12th Apr 07 at 11:08   View User's Profile U2U Member Reply With Quote
=PROPER("STFU")
nathy_87
Member
Registered: 14th Aug 08
Location: West Mids. Drives: Škoda Fabia VRS 5J
User status: Offline
12th Apr 07 at 11:22   View User's Profile U2U Member Reply With Quote
james your such a prick, wouldnt it be easier to just to go to each address (Ctrl +F) then type wha tit is then REpalce what it sould be just a thought as i cant think myself, i thought there was a button where you can change from lower-case-to upper-case vice versa, must jsut be on wrod, sorry Rachel
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
12th Apr 07 at 11:23   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by nathy_87
james your such a prick, wouldnt it be easier to just to go to each address (Ctrl +F) then type wha tit is then REpalce what it sould be just a thought as i cant think myself, i thought there was a button where you can change from lower-case-to upper-case vice versa, must jsut be on wrod, sorry Rachel


Why am I a prick, what I said is actually the way to do it
Hammer
Member
Registered: 11th Feb 04
User status: Offline
12th Apr 07 at 11:24   View User's Profile U2U Member Reply With Quote
This thread now has potential
Rachel H
Member
Registered: 12th Nov 03
Location: Berks
User status: Offline
12th Apr 07 at 11:25   View User's Profile U2U Member Reply With Quote
Yes it is the way to do it, but when I input the cells that need to be replaced I either get a 0 or VALUE in the cells?
nathy_87
Member
Registered: 14th Aug 08
Location: West Mids. Drives: Škoda Fabia VRS 5J
User status: Offline
12th Apr 07 at 11:25   View User's Profile U2U Member Reply With Quote
no it doesnt Hammer just becuase i called James a prick dont mean anything
nathy_87
Member
Registered: 14th Aug 08
Location: West Mids. Drives: Škoda Fabia VRS 5J
User status: Offline
12th Apr 07 at 11:26   View User's Profile U2U Member Reply With Quote
ok i stand corrected and apologiese to James
Rachel H
Member
Registered: 12th Nov 03
Location: Berks
User status: Offline
12th Apr 07 at 11:37   View User's Profile U2U Member Reply With Quote
Look you sub-humans whats the answer?
AdZ9
Member
Registered: 14th Apr 06
User status: Offline
12th Apr 07 at 11:37   View User's Profile U2U Member Reply With Quote
hahah, ur only helping and calling james a prick because its a girl doing it (unless its ollie)
jay kay
Member
Registered: 22nd Jan 06
Location: West Midlands
User status: Offline
12th Apr 07 at 11:38   View User's Profile U2U Member Reply With Quote
its ollie
AdZ9
Member
Registered: 14th Apr 06
User status: Offline
12th Apr 07 at 11:41   View User's Profile U2U Member Reply With Quote
nathy has probablly pm'd him asking to meet up and then he will show how its done won't now though knowing its ollie
Jules
Member
Registered: 26th Nov 04
Location: Ipswich, Suffolk Status: Happy
User status: Offline
12th Apr 07 at 12:19   View User's Profile U2U Member Reply With Quote
Ollie stop fucking about with work and waste some time! reply to my U2U that I sent from Me2U
I'm going to Tescos now and there better be a reply upon my return!
pow
Premium Member

Avatar

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
12th Apr 07 at 12:53   View Garage View User's Profile U2U Member Reply With Quote
It is indeed =PROPER(syntax)

You can also do =PROPER(A1) for example to alter text in cell A1

Nathy, we all learnt how to find and replate in IT in year 6, im sure she thought of that?
nathy_87
Member
Registered: 14th Aug 08
Location: West Mids. Drives: Škoda Fabia VRS 5J
User status: Offline
12th Apr 07 at 12:54   View User's Profile U2U Member Reply With Quote
obvisly not otherwise she would of done it fool
pow
Premium Member

Avatar

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
12th Apr 07 at 12:59   View Garage View User's Profile U2U Member Reply With Quote
She didnt do it because there is a formula to do it - remember, formulas like =SUM and shizzel?

And find and replace is supsetable to human error, and its just a long as doing it by hand.

Urgh. I refer to my prem lounge thread.
deano87
Member
Registered: 21st Oct 06
Location: Bedfordshire Drives: Ford Fiesta
User status: Offline
12th Apr 07 at 13:01   View User's Profile U2U Member Reply With Quote
She is a he too iirc.
pow
Premium Member

Avatar

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
12th Apr 07 at 13:03   View Garage View User's Profile U2U Member Reply With Quote
my bad if the above it true.
pow
Premium Member

Avatar

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
12th Apr 07 at 13:05   View Garage View User's Profile U2U Member Reply With Quote
*awaits nathys reply!
nathy_87
Member
Registered: 14th Aug 08
Location: West Mids. Drives: Škoda Fabia VRS 5J
User status: Offline
12th Apr 07 at 13:06   View User's Profile U2U Member Reply With Quote
all i got to say i was trying to be helpful thats all!then i get slated by Ollie & pow, what a site this is ay!
Rachel H
Member
Registered: 12th Nov 03
Location: Berks
User status: Offline
12th Apr 07 at 13:10   View User's Profile U2U Member Reply With Quote
Slated by Ollie? WTF I didn't say a thing Bert.

I tried what you said Pow but it just returns a 0 in the cell the forumla is in
pow
Premium Member

Avatar

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
12th Apr 07 at 13:12   View Garage View User's Profile U2U Member Reply With Quote
Oh, errm, works on mine when I try it?

Got a screenshot of what uve got?
Rachel H
Member
Registered: 12th Nov 03
Location: Berks
User status: Offline
12th Apr 07 at 14:13   View User's Profile U2U Member Reply With Quote
Sorted it mate, cheers.
pow
Premium Member

Avatar

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
12th Apr 07 at 14:14   View Garage View User's Profile U2U Member Reply With Quote
Good good, what did u do/use?

 
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		  
MS Word Help Darren Geek Day 9 728
26th Feb 04 at 09:58
by Darren		  
Rearranging letters abdus Off Day 4 184
20th Jun 06 at 19:46
by Sam		  
tigra saga mac1976 Scotland 2 221
19th Mar 07 at 22:14
by sri_davie		  
Converting from capital letters to proper on Excel? Rachel H Geek Day 0 94
12th Apr 07 at 10:57
by Rachel H		  

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