If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Quick Excel problem. Can I convert "FIRSTNAME SURNAME" to "Firstname Surname"

Zascar · 2006-09-13 13:37:14

I've got a large excel sheet with contact details, but everything is written in capitals. Does anyone know if there is a way to change this back to normal formal. "Firstname Surname" rather than "FIRSTNAME SURNAME"? I really don't want to have to do it manually Thanks

13-09-2006 01:37PM

#1

Zascar

Moderators, Motoring & Transport Moderators, Music Moderators Posts: 12,616 Mod ✭✭✭✭

Join Date: April 2001

Posts: 10351

I've got a large excel sheet with contact details, but everything is written in capitals. Does anyone know if there is a way to change this back to normal formal. "Firstname Surname" rather than "FIRSTNAME SURNAME"?

I really don't want to have to do it manually

Thanks

0

Comments

#2 13-09-2006 01:41PM

petes

Registered Users, Registered Users 2 Posts: 8,382 ✭✭✭

Join Date: August 2002

Posts: 8127

This shows how to do it on a single cell. Not sure about multiples yhough.

http://spreadsheets.about.com/cs/excelfunction1/qt/qtexchangecase.htm

0
#3 13-09-2006 02:22PM

Zascar

Moderators, Motoring & Transport Moderators, Music Moderators Posts: 12,616 Mod ✭✭✭✭

Join Date: April 2001

Posts: 10351

Legend! Cheers Petes

0