I hit Post too quickly. You can put this in a blank column next to your data
(adjusting the cell references as needed) and copy down. Then, copy the cells
with the Formula and do Edit | Pate Special | Values.
If the data matches what you want, delete the original column.
If VBA is an option for you, Bob Phillips's post should do the trick.
--
tj
"tjtjjtjt" wrote:
This seems to be working for me:
=LEFT(A10,FIND("-",A10,1))&0&MID(A10,FIND("-",A10,1)+1,255)&"-03"
--
tj
"GR" wrote:
Have column of numbers that must be converted to a new number by simply
adding same to number is two specific places. ex: 6200-80 must become
6200-080-3
How to do this w/out re-keying entire workbook?
|