Thread: Obtain last four characters from a cell.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mohd21uk via OfficeKB.com
 
Posts: n/a
Default Obtain last four characters from a cell.
I am using a macro to validate a form. I would like cell A1 to equate to the
last four charecters of cell a4. For e.g if cell a1 is 552004k00 cell a4
should have the value 4k00. I would be grateful if you could provide this to
me in VBA code.

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200605/1
Reply With QuoteReply With Quote