Thread: Copying part of a cell to a new cell
View Single Post
 
Old 01-27-2012, 06:13 AM
paulw793 paulw793 is offline Windows XP Office 2010 32bit
Novice
  
Join Date: Sep 2011
Posts: 5
paulw793 is on a distinguished road
Default [SOLVED] Copying part of a cell to a new cell
I've got a list from 2008-2012 with 1665 rows of manholes.

What I need to do is go through it and copy the street number from column D to column C and copy the MH# from column D to column E.
Aside from manually going through each on and typing it running the risk of error, is there a VBA code I can put in? Also if there is any way that I could easily delete the street number and MH# from column D afterward it would be awesome...

I've attached the file so you can see what I'm talking about.
Last edited by paulw793; 01-27-2012 at 10:47 AM.
Reply With Quote