View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jposner jposner is offline
external usenet poster
 
Posts: 1
Default delete left 8 characters in many cells

I'd like to ask if someone could provide a macro that would do th
following.

I have several rows in one column.

Looks like:

2000001_JSJSLSLS.tif

I'd like to just be able to run through the entire column (approx 630
rows) and delete the 8 Left characters while leaving the remainin
characters in the cell.

Result like:

JSJSLSLS.tif


Any help appreciated.

Thanks

--
Message posted from http://www.ExcelForum.com