Arghhh - can't convert text font to Upper CASE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DianaH - 28 Sep 2004 20:15 GMT

I have one column of text and I want to convert it from
mixed to UPPER Case. I thought I was following the
instructions (in help) correctly, but it keeps saying that
I have circular reference for the formula where text
= "upper" for either 1 single cell or a number of cells in
the column.

Using Office 2002. Thanks for any help/suggestions.
Diana

Reply to this Message

Frank Kabel - 28 Sep 2004 20:25 GMT

Hi
you have to use the formula
=UPPER(A1)
in a DIFFERENT cell and not in the same cell as the text resides in

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> I have one column of text and I want to convert it from
> mixed to UPPER Case. I thought I was following the
[quoted text clipped - 5 lines]
> Using Office 2002. Thanks for any help/suggestions.
> Diana

Reply to this Message

dianah - 28 Sep 2004 20:48 GMT

Thank you Frank,
However, I'm still missing something in the process.

As you instructed, I put my cursor in a different cell.
I clicked fx, (to enter a formula), then I
selected "UPPER" and then highlighted the range (all of
the B column). In the cell I was in ... it now reads:
=UPPER(B:B)
when I click it, the b colums has a blue line around it,
however, the case did not change. I did a print preview
and it doesn't look different either.

What am I doing wrong?

>-----Original Message-----
>Hi
[quoted text clipped - 18 lines]
>
>.

Reply to this Message

Frank Kabel - 28 Sep 2004 20:52 GMT

Hi
you can only use one single cell. So enter
=UPPER(B1)

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Thank you Frank,
> However, I'm still missing something in the process.
[quoted text clipped - 38 lines]
> >
> >.

Reply to this Message

DianaH - 28 Sep 2004 21:32 GMT

Frank, I had tried that as well ... didn't make a
difference.

I also copied/pasted your text and it looked the same as
mine. I considered that maybe it just needs to be
printed ... but that wasn't it.

Something is a-miss and I'm mystified by it.

Supplemental ... I've got it. The data in this excel file
was originally a data file for a word merge document.
Word puts merge data in access format (which was driving
me crazy, because I couldn't open it to make global
changes). I then decided that I could import it into
Excel (that was easy). However, there must have been
something about the import that was preventing the above
formula from working properly. I decided to copy/paste
the entire contents into a new worksheet and now it's
working. So, what I need to do, is figure out where to
put that information so that the upper case format (of the
destination cells) is what is picked up by word in the
merge.

Talk about confusing!

-----Original Message-----
Hi
you can only use one single cell. So enter
=UPPER(B1)

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

"dianah" <anonymous@discussions.microsoft.com schrieb im
Newsbeitrag
news:3d2a01c4a594$31f06f00$a301280a@phx.gbl...
Thank you Frank,
However, I'm still missing something in the process.

As you instructed, I put my cursor in a different cell.
I clicked fx, (to enter a formula), then I
selected "UPPER" and then highlighted the range (all of
the B column). In the cell I was in ... it now reads:
=UPPER(B:B)
when I click it, the b colums has a blue line around it,
however, the case did not change. I did a print preview
and it doesn't look different either.

What am I doing wrong?

-----Original Message-----
Hi
you have to use the formula
=UPPER(A1)
in a DIFFERENT cell and not in the same cell as the text
resides in

--
Regards
Frank Kabel
Frankfurt, Germany

"DianaH" <anonymous@discussions.microsoft.com schrieb im
Newsbeitrag
news:3cd001c4a58f$7eaf4aa0$a301280a@phx.gbl...
I have one column of text and I want to convert it from
mixed to UPPER Case. I thought I was following the
instructions (in help) correctly, but it keeps saying
that
I have circular reference for the formula where text
= "upper" for either 1 single cell or a number of cells
in
the column.

Using Office 2002. Thanks for any help/suggestions.
Diana

Reply to this Message

David McRitchie - 28 Sep 2004 23:21 GMT

What do you currently have in the cell that you want to make uppercase.
A circular reference is trying to update from itself or a cell based
on a value of the current cell.

My own preference is to always use a macro fix the text constants.

Assuming it is something you typed in so that you are looking at
constants and not formulas.

To fix existing entries use a macro see Upper_Case macro at
http://www.mvps.org/dmcritchie/excel/proper.htm#upper

To correct entries just after entering them use a Change Event Macro
like the one found just below the above subroutine.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Frank, I had tried that as well ... didn't make a
> difference.
[quoted text clipped - 74 lines]
> Using Office 2002. Thanks for any help/suggestions.
> Diana

Reply to this Message