Copy a column in worksheet with a character change
HI
Is there a way to copy the contents of one column to another, but change say
the fifth character of each cell to a different character? For instance, I
have a value of MLPM1 in a column (in each cell) with repetitive data and
want to copy that column but change the 5th character to "2" so that it reads
MLPM2-(data). Can anybody help? Thanks in advance!
Scott
|