Thread: Stripping The First Four Characters from a value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Harlan Grove Harlan Grove is offline
external usenet poster
  
Posts: 733
Default Stripping The First Four Characters from a value
Rob wrote...
What I am trying to figure out is how I can remove the first four characters
via a VBA Macro from a value of a cell.
....

Try

somecell.Value = Mid(somecell.Value, 5)

Reply With QuoteReply With Quote