Thread: Trim
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
 
Posts: 519
Default Trim

Thankyou Will.

"WillR" wrote:

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.