ulfal029
01-11-2008, 03:38 AM
I'm looking for a way to delete 7 characters, starting from right, from a string in a cell:
TEST 2 xxxxxxx
to
TEST 2
The total number of characters may vary, but keep all except the 7 ones starting from right.
Label1.Caption = Range("A2")....?
Thank you.
TEST 2 xxxxxxx
to
TEST 2
The total number of characters may vary, but keep all except the 7 ones starting from right.
Label1.Caption = Range("A2")....?
Thank you.