Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert names into initial caps
Hi there,
I have a column of names like SANDRA, JIM that I would like to convert to Sandra, Jim etc but I don't know how to do it and there are 3500 of them. Is there anyway to do this without retyping them? Any help would be great. Thanks Connie |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert names into initial caps
Insert a column next to your data. In that column, enter the
formula =PROPER(A1) and copy down as far as you need to go. Then, select those cells, copy them, select the first original cell, go to the Edit menu, choose Paste Special, and choose the Values option. You could also use a VBA macro. Sub AAA() Dim Rng As Range For Each Rng In Application.Intersect(Columns(1), _ ActiveSheet.UsedRange).Cells Rng.Value = StrConv(Rng.Text, vbProperCase) Next Rng End Sub Here, change Columns(1) to the appropriate column number. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Grd" wrote in message ... Hi there, I have a column of names like SANDRA, JIM that I would like to convert to Sandra, Jim etc but I don't know how to do it and there are 3500 of them. Is there anyway to do this without retyping them? Any help would be great. Thanks Connie |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert names into initial caps
Hi
If your data is in column A, then in B1 (or any other spare column on the sheet) enter =Proper(A1) Copy down as far as required. Mark the range of cells in the column where you have put the formula, which are now in Proper Form, move cursor to cell A1 and Paste SpecialValues You can then delete the helper column. -- Regards Roger Govier "Grd" wrote in message ... Hi there, I have a column of names like SANDRA, JIM that I would like to convert to Sandra, Jim etc but I don't know how to do it and there are 3500 of them. Is there anyway to do this without retyping them? Any help would be great. Thanks Connie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding the common names between columns | Excel Discussion (Misc queries) | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
How can I convert all Caps to first letter caps in Excel? | Excel Worksheet Functions | |||
In excel, how do you convert to caps? | Excel Discussion (Misc queries) | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) |