i have attached my excelsheet Please help me out I am struck here
i ahve continous fraction numbers in every attribute value
how can i write vba code for replacing continuos fraction numbers in on row
Attribute name1 Attribute Value1
materials1 1/2 IN ID, 2/3 IN LG, 4/5 IN OD 1/4 IN THK
materials2 1/2 IN ID, 2/3 IN LG, 4/5 IN OD
materials3 1/2 IN ID, 2/3 IN LG
example: 1/2 IN ID, 2/3 IN LG, 4/5 IN OD 1/4 IN THK in a single row
i have TOOL OUT sheet
ModelNumber Attribute Value Replace Value
1 materials 2/4 IN LG, 3/4 IN ID, 5/9 IN OD,1/15 IN THK
2 materials 1/2 IN LG, 2/9 IN
3 materials 4/15 IN
4 materials 5/18 IN
5 materials 4/19 IN
6 materials 2/4 IN
7 materials 1/2 IN
8 materials 4/15 IN
9 materials 5/18 IN
10 materials 4/19 IN LG, 9/8 IN
11 materials 2/4 IN LG, 3/4 IN ID, 5/9 IN OD,1/15 IN THK
iwant this to converted in (Replace value column)
example 0.5 IN LG, 0.75 IN ID, 0.55 IN OD,0.06 IB THK
Bookmarks