Switch
New Member
- Joined
- Nov 10, 2002
- Messages
- 7
Hi all,
Can anyone tell me how to write a formula that will change the original text in Col A of this example to read as the text in columnB on the example.
Thank you
Switch
Can anyone tell me how to write a formula that will change the original text in Col A of this example to read as the text in columnB on the example.
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | OriginalTextinthiscolumn | Formulamustreturnthis | ||||
2 | AntioxidantPlus(60)_03630 | 03630_AntioxidantPlus(60) | ||||
3 | AvenaComplex(42)_03346 | 03346_AvenaComplex(42) | ||||
4 | BioC-Complex1000(60)_03624 | 03624_BioC-Complex1000(60) | ||||
5 | Bio-CComplex125g_03606 | 03606_Bio-CComplex125g | ||||
6 | Bio-ChromiumPlus(60)_03633 | 03633_Bio-ChromiumPlus(60) | ||||
7 | Bio-Disc(60)_03634 | 03634_Bio-Disc(60) | ||||
8 | ||||||
9 | ||||||
Sheet1 |
Thank you
Switch