Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capitize first letter in sequence
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capitize first letter in sequence
Use the PROPER function:
=PROPER(A1) Hope this helps. Pete On Apr 20, 12:37*am, dberger16 wrote: Hi, here is an example of data in my column: Lorena & james i simply want to capitize the J (james). Thanks for your assistance DaveB |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capitize first letter in sequence
PROPER should do it ..
Assuming data in A1 down, eg: Lorena & james In B1, copied down: =PROPER(TRIM(A1)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "dberger16" wrote: Hi, here is an example of data in my column: Lorena & james i simply want to capitize the J (james). Thanks for your assistance DaveB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
How do I get the columns in Excel to go back to letter sequence | Excel Discussion (Misc queries) | |||
How do I get the columns in Excel to go back to letter sequence | Excel Discussion (Misc queries) |