Font Format

M

mira

I have merged two different sets of data where one sheet has names in all
caps and the other not in all caps. When I'm doing a pivot table, it is
using the names as two different values. There is no option in the font
format to make the non-cap names into all caps. How can I make the font all
consistent so that it is not appearing as two different values.

Thanks!
 
D

Doug Kanter

mira said:
I have merged two different sets of data where one sheet has names in all
caps and the other not in all caps. When I'm doing a pivot table, it is
using the names as two different values. There is no option in the font
format to make the non-cap names into all caps. How can I make the font
all
consistent so that it is not appearing as two different values.

Thanks!
Click to expand...

Take a look at the UPPER, LOWER and PROPER functions, for converting the
case of text.
 
M

mira

Thanks, Doug!

Do you also happen to know how I can remove the last character in a column?
My problem is that some of the names that are capped have a comma after it,
and the non-capped names don't have the comma after the name. I want to
remove the comma if it is the last character of the field. Thnks.
 
D

Doug Kanter

Mira:
Look at the LEFT and RIGHT functions. Matter of fact, click Insert,
Function, select the Text category, and look at all of them. There's some
very cool stuff available. And, as you click the "Next" button for each
function, you'll see hints about how to use each one.
 
Top