lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
What is the best way to get rid of numbers in the column below? I only want "John" name to appear without numbers. I can do Find/Replace, or use nested Substitute() but has to be nested. Is there better way to do that? Thank you very much
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
What is the best way to get rid of numbers in the column below? I only want "John" name to appear without numbers. I can do Find/Replace, or use nested Substitute() but has to be nested. Is there better way to do that? Thank you very much
john1 |
john2 |
john3 |
john4 |
john5 |
john6 |
john7 |
john8 |
john9 |
john10 |
john11 |
john12 |
john13 |
john14 |
john15 |
john16 |
john17 |
john18 |
john19 |
john20 |
john21 |
john22 |
john23 |
john24 |
john25 |
john26 |
john27 |
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>