Excel 2000 capitalization help

D

Dan

We have a 1500 record spreadsheet that has mixed lower
and upper case in their cells. We would like to convert
all records to upper case automatically. We've tried the
formula Excel provides =Upper (cell to cell) without any
luck.

does anyone have any suggestions?

Thx

DAN
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upper Case Conversion 4
Excel: how to convert text to upper case upon entry? 13
UPPER function 2
UPPER CASE formatting a cell 1
Upper / Fill Series Function in Excel 7
Converting irregular Word table to spreadsheet 4
If Condition 4
Excel Capitalization 5

Top