Data validation issue

Hello,

I have had to consolidate data into a summary. The data involves ad-hoc rows but they remain unchanged. Only the column change but unfortunately it is not set in a format where I can drag the data horizontally to reflect the correct column.

For example I have the following list and I would like to be able to select it and change the "L" to "G" across the list.

L78
L85
L91
L99
L130

I'm trying to get
G78
G85
G91
G99
G130

Any help would be highly appreciated

Did you try Edit|Replace and replace the L with G?

You should update your profile to state you are using 2007, not 2003.

Select the range to change and go to Home tab.. Find & Select (far right) and then Replace

Find What: L
Replace With: G