Hi all,
I have a column of values, though some of these cells contain 4 extra characters (AABD) at the end and i want to remove when i run my macro, my problem being, with Mid / Left / Right i cant seem to specify as the cell lengths are all different.
So say:
Many Thanks![]()
If Len(strCell) > 0 Then If Right(strCell, 4) = "####" Then 'remove last 4 characters from strCell End If End If
Bookmarks