Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula for Formatting Fonts
I have a spreadsheet that consists of Names and Addresses, however they are
all in capital letters. There are about 600 entries. It'll take me forever if I edit each one manually. What formula should I use to make the Names not all caps. For ex. JOE SMITH becomes Joe Smith. Last Name is in one column and the First Name in another column. Please Help! Thank you so much :) |
#2
|
|||
|
|||
Assuming the names are in cols A and B, from row1 down,
Put in C1: =PROPER(A1) Copy C1 to D1, fill down as required Select cols C and D, and then do a copy paste special as values to overwrite cols A and B (try on a *spare* copy first) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Jane" wrote in message ... I have a spreadsheet that consists of Names and Addresses, however they are all in capital letters. There are about 600 entries. It'll take me forever if I edit each one manually. What formula should I use to make the Names not all caps. For ex. JOE SMITH becomes Joe Smith. Last Name is in one column and the First Name in another column. Please Help! Thank you so much :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Help with macro formula and variable | Excel Worksheet Functions |