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.

"mira" wrote in message
...
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.

"Doug Kanter" wrote:


"mira" wrote in message
...
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!

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