Using the PROPER/LOWER/UPPER commands
 

Hello. Please help me format the entire column with more than 5,000 records
using the PROPER command. From the Offline and Online Help, it only shows
formatting of a text in only one cell after the other. But I have tons of
records to format! Need your help! Thanks!

Using the PROPER/LOWER/UPPER commands
 

If you want your data as text back in column A, do the following:

1. Copy column B
2. While column B is still highlighted, right click, choose Paste Special...,
Values
3. Delete column A

--
Regards,
Fred


"Teethless mama" wrote in message
...
Let's say your data in Column A2:A5000
In B2 =PROPER(A2)
Copy down to B5000


"Mickoloney" wrote:

Hello. Please help me format the entire column with more than 5,000 records
using the PROPER command. From the Offline and Online Help, it only shows
formatting of a text in only one cell after the other. But I have tons of
records to format! Need your help! Thanks!