Thread
:
Trim
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
WillR
external usenet poster
Posts: 6
Trim
either
=RIGHT(A1,3)
or
=MID(A1,3,3)
where A1 is B0101
--
Kind Regards,
Will Riley
"Steved" wrote:
Hello from Steved
I would like to trim B0101 to 101 please.
I know how to do it but right now I just cannot remember how.
Thankyou.
Reply With Quote
WillR
View Public Profile
Find all posts by WillR