I've just about managed to get excel to delete a character/characters in the middle of a cell using visual basic using the following code:
With Cells(1, 1)
.Characters(3, 2).Delete
End With
But what I would like to do is do further manipulation, including:
- Determining the length of a string and getting it into a variable
- Deleting the last character in a string of unknown length...