Change all instances of A,B,C,D to G
 

Hi,
I keep a chart that indicates students' grades in various courses (column A
lists the student name, Row 1 the course and Rows 2-22 and Columns B-G list
the grades received: A,B,C,D, F, Inc). Once a month, I need to share
information that students received a grade, but not indicate which grade they
received, unless they received an F or Inc, which should stay noted.

Is there a way to change all instances of "A" "B" "C" "D" to "G"?

Or can someone think of some other way to achieve what I'm trying to do?
Thanks so much for any assistance.

--
Julie

Change all instances of A,B,C,D to G
 

One quick way
Sub gradechange()
lr=cells(rows.count,"b").end(xlup).row
myarray = Array("a", "b", "c", "d")
For Each l In myarray
Range("b2:g" & lr).Replace l, "g"
Next l
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Julie" wrote in message
...
Hi,
I keep a chart that indicates students' grades in various courses (column
A
lists the student name, Row 1 the course and Rows 2-22 and Columns B-G
list
the grades received: A,B,C,D, F, Inc). Once a month, I need to share
information that students received a grade, but not indicate which grade
they
received, unless they received an F or Inc, which should stay noted.

Is there a way to change all instances of "A" "B" "C" "D" to "G"?

Or can someone think of some other way to achieve what I'm trying to do?
Thanks so much for any assistance.

--
Julie

Change all instances of A,B,C,D to G
 

If you're using office 2002+, you can use:
Insert|symbol

Chip Pearson has an addin that may help (if you're using xl2k or lower).
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)

Julie wrote:

Hi,
I keep a chart that indicates students' grades in various courses (column A
lists the student name, Row 1 the course and Rows 2-22 and Columns B-G list
the grades received: A,B,C,D, F, Inc). Once a month, I need to share
information that students received a grade, but not indicate which grade they
received, unless they received an F or Inc, which should stay noted.

Is there a way to change all instances of "A" "B" "C" "D" to "G"?

Or can someone think of some other way to achieve what I'm trying to do?
Thanks so much for any assistance.

--
Julie

--

Dave Peterson

Change all instances of A,B,C,D to G
 

Select the range to fix and do 4 edit|replaces????

Julie wrote:

Hi,
I keep a chart that indicates students' grades in various courses (column A
lists the student name, Row 1 the course and Rows 2-22 and Columns B-G list
the grades received: A,B,C,D, F, Inc). Once a month, I need to share
information that students received a grade, but not indicate which grade they
received, unless they received an F or Inc, which should stay noted.

Is there a way to change all instances of "A" "B" "C" "D" to "G"?

Or can someone think of some other way to achieve what I'm trying to do?
Thanks so much for any assistance.

--
Julie

--

Dave Peterson

Change all instances of A,B,C,D to G
 

Oops. This is in the wrong thread.

Dave Peterson wrote:

If you're using office 2002+, you can use:
Insert|symbol

Chip Pearson has an addin that may help (if you're using xl2k or lower).
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)

Julie wrote:

Hi,
I keep a chart that indicates students' grades in various courses (column A
lists the student name, Row 1 the course and Rows 2-22 and Columns B-G list
the grades received: A,B,C,D, F, Inc). Once a month, I need to share
information that students received a grade, but not indicate which grade they
received, unless they received an F or Inc, which should stay noted.

Is there a way to change all instances of "A" "B" "C" "D" to "G"?

Or can someone think of some other way to achieve what I'm trying to do?
Thanks so much for any assistance.

--
Julie

--

Dave Peterson

--

Dave Peterson