ExcelBanter - Using the PROPER/LOWER/UPPER commands

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Using the PROPER/LOWER/UPPER commands (https://www.excelbanter.com/excel-discussion-misc-queries/120687-re-using-proper-lower-upper-commands.html)

Teethless mama

Using the PROPER/LOWER/UPPER commands

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!

All times are GMT +1. The time now is 07:46 PM.