Hello Guys,

I have a question here..


I have a cell that has this

ALG-g30

And I have another cell that looks like this

ADL G28 Clear Lamp Chimney 8-1/2 inches

I want the cell to look like this
ADL G30 Clear Lamp Chimney 8-1/2 inches


Basically I want to take the g30 and convert the "G" to uppercase and add it with the "30" to the other cell..

I need to do that with 40 rows..

How would I do that?

I copied the rows here down here --- http://screencast.com/t/MCkgJM6N9

Thanks, Dan