Thread
:
Convert column data to trim all characters and leave the last 6
View Single Post
#
1
Posted to microsoft.public.excel.programming
S Himmelrich
external usenet poster
Posts: 76
Convert column data to trim all characters and leave the last 6
I'm trying to recall the
vb
syntax to perform the above function,
which will evaluate each row in a column that will have this type of
data:
3180015155 002075
and replace the current data with the last 6 characters like this:
002075
recommendations?
Reply With Quote
S Himmelrich
View Public Profile
Find all posts by S Himmelrich