Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
proper case using Microsoft Office Professional 2003
I have a column in excel with names that show for example WHITE, MARY I
want to change the names in the column to show the last name in one column and the first name in the second column. I also want to change from all caps to just the first initial in the last name and first name capitalized. Also, can I change the whole column at once? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
proper case using Microsoft Office Professional 2003
On Aug 5, 4:10*pm,
m wrote: I have a column in excel with names that show for example WHITE, MARY * * I want to change the names in the column to show the last name in one column and the first name in the second column. *I also want to change from all caps to just the first initial in the last name and first name capitalized. * Also, can I change the whole column at once? Are you referring to wanting to do this in Excel, firstly? You can use Text to columns, parse the data and use the LEFT function to amend the case. Let me know HTH :-D |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
proper case using Microsoft Office Professional 2003
First I changed the data by typing =Proper(A2) in cell B2 and then copied the
formula down through the column. Then I used the text to columns. Is there a quicker way? "Simon" wrote: On Aug 5, 4:10 pm, m wrote: I have a column in excel with names that show for example WHITE, MARY I want to change the names in the column to show the last name in one column and the first name in the second column. I also want to change from all caps to just the first initial in the last name and first name capitalized. Also, can I change the whole column at once? Are you referring to wanting to do this in Excel, firstly? You can use Text to columns, parse the data and use the LEFT function to amend the case. Let me know HTH :-D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exel error 1706 microsoft office 2000 sr-1 professional | Excel Discussion (Misc queries) | |||
Microsoft Office xp Professional Front page | Excel Discussion (Misc queries) | |||
windows is configuring my microsoft office xp professional | Excel Discussion (Misc queries) | |||
cancel Microsoft office 2000 SR-1 Professional | Setting up and Configuration of Excel | |||
How do I Set up a Invoice in Microsoft Office 2000 Professional (. | New Users to Excel |