Thread: How to delete fist 6 digit of all contents in a column?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default How to delete fist 6 digit of all contents in a column?
presume E is a column of blank cells, go to E1 and insert the formula:
=Right(D1,LEN(D1)-6)
then copy down
Reply With QuoteReply With Quote