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

Corsa Sport » Message Board » Off Day » Geek Day » MS Word Help


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 MS Word Help
Darren
Member
Registered: 21st Apr 02
Location: Hadleigh, Suffolk
User status: Offline
   26th Feb 04 at 09:25   View User's Profile U2U Member Reply With Quote
Is there any way of formatting a block of text that is in capital letters to 'little' letters??

cheers
Tracey
Member
Registered: 27th Aug 03
User status: Offline
26th Feb 04 at 09:27   View User's Profile U2U Member Reply With Quote
under format on the tool bar- there should be an option thats titled change case- tere is on mine
Adam-CorsaC18s
Member
Registered: 7th Apr 03
Location: Royston, South Yorkshire
User status: Offline
26th Feb 04 at 09:27   View User's Profile U2U Member Reply With Quote
Yes mate - highlight the text then click on teh Format menu, and click on Change Case. choose the case you want and click OK - jobs a good un.
Darren
Member
Registered: 21st Apr 02
Location: Hadleigh, Suffolk
User status: Offline
26th Feb 04 at 09:28   View User's Profile U2U Member Reply With Quote
actually i meant Excel - not word
Adam-CorsaC18s
Member
Registered: 7th Apr 03
Location: Royston, South Yorkshire
User status: Offline
26th Feb 04 at 09:29   View User's Profile U2U Member Reply With Quote
copy it to word and do it in there then copy it back?
Darren
Member
Registered: 21st Apr 02
Location: Hadleigh, Suffolk
User status: Offline
26th Feb 04 at 09:30   View User's Profile U2U Member Reply With Quote
i think that may be a bit complicated - ive got like 6,000 rows to change
Adam-CorsaC18s
Member
Registered: 7th Apr 03
Location: Royston, South Yorkshire
User status: Offline
26th Feb 04 at 09:38   View User's Profile U2U Member Reply With Quote
wanna mail me the document and ill have a look for you? adam.farah@btopenworld.com if ya do.
Darren
Member
Registered: 21st Apr 02
Location: Hadleigh, Suffolk
User status: Offline
26th Feb 04 at 09:40   View User's Profile U2U Member Reply With Quote
i cant really mate - its work and its one mutha fucker of a claims spreadsheet - 4.11mb
Adam-CorsaC18s
Member
Registered: 7th Apr 03
Location: Royston, South Yorkshire
User status: Offline
26th Feb 04 at 09:46   View User's Profile U2U Member Reply With Quote
Fair enough, try this:
You should be able to select all the spreadsheet and go Edit > Copy then go into Word and do a Edit > Paste (not Paste Special) it'll import the spreadsheet into word and just select the whole thing again in word and Go Format > Change Case change it to what you want and Copy it again and paste it back into Excel.
Ive just tried it and it works. (save spreadsheet before you try it tho!! and check all your formulas have stayed in before you save it after changing the case!!)
Hope this helps mate.
Darren
Member
Registered: 21st Apr 02
Location: Hadleigh, Suffolk
User status: Offline
26th Feb 04 at 09:58   View User's Profile U2U Member Reply With Quote
Thank Adam I'll give it a go. Thank also Tracey

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
for anyone who is bored Kerry General Chat 98 3225
13th Mar 03 at 23:30
by Drew		  
best film tical2003 General Chat 52 1777
2nd Apr 03 at 09:09
by Miss CorsaSri		  
p.c help (i know im fick) Kerry Geek Day 14 1166
10th Jul 03 at 18:02
by Skinz		  
For C20XE owners... Paul_J Help Zone, Modification and ICE Advice 5 686
22nd Dec 03 at 18:11
by luca2020		  
I may be crossing back over from the dark side Colin General Chat 86 2799
14th Feb 04 at 12:37
by Colin J		  

Corsa Sport » Message Board » Off Day » Geek Day » MS Word Help 29 database queries in 0.0159650 seconds