=REPLACE(A1,10,1," ")
I'm assuming that the 'S' will always be the 10th character or this wont
work,
Regards,
"McDal" wrote in message
...
I need to replace in all my thousands of part numbers.....position number
10
which is the letter "S" to a blank.
Does anybody know how to do this?
|