|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
|
|
Thread Tools | Display Modes |
Dec 3rd, 2003, 09:47 PM
|
#1 |
Join Date: Jul 2002
Location: Leeds, UK
Posts: 517
|
Doing it PROPERly
I need staff names drawn from a spreadsheet to produce name badges (amongst other things)
Using PROPER, I can overcome most of their Capitalisation problems, but when it comes to those damn Scots like McDonald and MacIntosh I'm having problems. How can I capitalise the 3rd or 4th letter, as well as the 1st, if the second and third letters are either "c" or "ac" ? Thanks in advance
__________________
I got a sweater for Christmas. I really wanted a screamer or a moaner. |
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode