|
|
|||||||
| Notices |
| Off Topic Non-Graphic and Web Design Related Chat |
 |
|
|
LinkBack (1) | Thread Tools | Display Modes |
05-11-2007, 08:50 AM
|
||||
|
||||
Any plugins or methods on spreadsheet?
I have a spreadsheet file with over 5,000 names, some are all in capital letters and some are spelt fine.
My question is, is there a plugin or a method of making all the names have a capital letter at the beginning and normal letters after? I dont want to edit 5,000 names, it will take me forever... Thank you!
__________________
http://housemusic4life.blogspot.com/           
|
|
|
|
05-11-2007, 09:02 AM
|
||||
|
||||
|
__________________
Colour Printing and Integrated Cards || Graphic Design, Web Design UK || Logo Designer - Logo Design || Graphic Design Blog || Logo Design Logo Designer || Integrated Labels & Cards || Logo Design || Graphic Design Links || Web Design Rotherham UK || Logo Design UK || Web Design UK        
|
|
05-11-2007, 09:06 AM
|
||||
|
||||
|
Hmmm, isnt that CSS? That wont work in spreadsheet will it? If so how?
__________________
http://housemusic4life.blogspot.com/
|
|
05-11-2007, 09:09 AM
|
||||
|
||||
|
Copy the text into an blank html doc, use the converter and then paste it back into the spreadsheet
__________________
Colour Printing and Integrated Cards || Graphic Design, Web Design UK || Logo Designer - Logo Design || Graphic Design Blog || Logo Design Logo Designer || Integrated Labels & Cards || Logo Design || Graphic Design Links || Web Design Rotherham UK || Logo Design UK || Web Design UK
|
|
05-11-2007, 10:02 AM
|
||||
|
||||
|
Tried it, wont work...
I also have other fields which need to be changed like address etc... There HAS to be a spreadsheet plugin for this, lots of people must have run into this problem.
__________________
http://housemusic4life.blogspot.com/
|
|
05-11-2007, 10:05 AM
|
||||
|
||||
|
Excel
__________________
http://housemusic4life.blogspot.com/
|
|
05-11-2007, 10:10 AM
|
||||
|
||||
|
Try Ctrl+A then Shift+F3. It works in Word to toggle caps styles, try Excel.
EDIT: Search "caps" in Excel's help. First item.
__________________
Standards Compliant Web Consulting and Development | Labs - Free Snippets and Codes | CSS Wizardry Last edited by PR Design; 05-11-2007 at 10:14 AM.
|
|
05-11-2007, 10:24 AM
|
||||
|
||||
|
Ok thanks for your help, I've found a formula in Excel called PROPER and it makes the start uppercase and the rest lowercase.
I just need to figure out how to do it....anyone?
__________________
http://housemusic4life.blogspot.com/
|
|
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Firefox Plugins | Toon | Web Browsers Forum | 44 | 04-07-2008 06:50 AM |
| Old WordPress plugins (removing) | PolarBear | General Web Design Forum | 7 | 09-01-2008 03:20 PM |
| Free Photoshop Plugins | Graphic Design Links | Graphic Design Links | 0 | 03-01-2008 07:21 PM |
| Free Social Network Wordpress Plugins | Graphic Design Links | Graphic Design Links | 0 | 18-12-2007 08:00 AM |
| Wall art printing methods? | sabian1982 | Graphic Design and Web Design Help | 0 | 06-08-2007 02:23 PM |
| All times are GMT. The time now is 06:28 PM. |
Linear Mode
