Smokeyham
Board Regular
- Joined
- Feb 1, 2006
- Messages
- 120
- Office Version
- 365
- Platform
- Windows
Hello,
I thought this would be quite simple to do, but so far have not found a solution. I would like to take a value in a cell and remove the second and third characters in that cell.
For example: "V0010" would become "V10."
I've found formulas for removing the beginning and ending characters, but not a way to remove from the middle.
Any help would be appreciated.
Thanks....
I thought this would be quite simple to do, but so far have not found a solution. I would like to take a value in a cell and remove the second and third characters in that cell.
For example: "V0010" would become "V10."
I've found formulas for removing the beginning and ending characters, but not a way to remove from the middle.
Any help would be appreciated.
Thanks....