View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jfcby[_2_] jfcby[_2_] is offline
external usenet poster
 
Posts: 121
Default Change cell data using excel 2003

Hello,

I have 100 worksheets with 3 columns of data and 1 row to 500 rows. In
column C my data looks like so
125
252
CO125
CO314
MECH
MECH2

This is my question -
How can I change my data in the cells with CO125 or CO314 to look like
this 125CO or 314CO?

I've searched for code to help me but I've been unsuccessful! Please
Help!

Thank you for help,
jfcby