HI
Please help me with the following.
I have the following data as "SKU" I require a formula to look for "ORG" and replace as "ORA" . I cannot use the find and replace as the data is live dump hence require a formula.
<colgroup><col><col></colgroup><tbody>
</tbody>
Thanks and regards,
Please help me with the following.
I have the following data as "SKU" I require a formula to look for "ORG" and replace as "ORA" . I cannot use the find and replace as the data is live dump hence require a formula.
SKU | require the following |
1570T1-ORG-R087 | 1570T1-ORA-R087 |
1570T1-ORG-R092 | 1570T1-ORA-R092 |
1570T1-ORG-R097 | 1570T1-ORA-R097 |
1570T1-ORG-R102 | 1570T1-ORA-R102 |
1570T1-ORA-R087 | 1570T1-ORA-R087 |
1570T1-ORA-R092 | 1570T1-ORA-R092 |
1570T1-ORA-R097 | 1570T1-ORA-R097 |
1570T1-ORA-R102 | 1570T1-ORA-R102 |
1500T1-ORG-DM | 1500T1-ORA-DM |
1500T1-ORG-EL | 1500T1-ORA-EL |
1500T1-ORG-FXL | 1500T1-ORA-FXL |
1500T1-ORG-G2XL | 1500T1-ORA-G2XL |
1500T1-ORG-G3XL | 1500T1-ORA-G3XL |
1500T1-ORG-G4XL | 1500T1-ORA-G4XL |
1500T1-ORG-G5XL | 1500T1-ORA-G5XL |
1500T1-ORA-CS | 1500T1-ORA-CS |
1500T1-ORA-DM | 1500T1-ORA-DM |
1500T1-ORA-EL | 1500T1-ORA-EL |
1500T1-ORA-FXL | 1500T1-ORA-FXL |
1500T1-ORA-G2XL | 1500T1-ORA-G2XL |
1500T1-ORA-G3XL | 1500T1-ORA-G3XL |
1500T1-ORA-G4XL | 1500T1-ORA-G4XL |
1500T1-ORA-G5XL | 1500T1-ORA-G5XL |
<colgroup><col><col></colgroup><tbody>
</tbody>
Thanks and regards,