Arghhh - can't convert text font to Upper CASE

  • Thread starter Thread starter DianaH
  • Start date Start date
D

DianaH

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
 
Hi
you have to use the formula
=UPPER(A1)
in a DIFFERENT cell and not in the same cell as the text resides in
 
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?
 
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)

--
Regards
Frank Kabel
Frankfurt, Germany

"dianah" <[email protected] schrieb im
Newsbeitrag
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" <[email protected] schrieb im
Newsbeitrag
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
 
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.
 
Back
Top