Thread: How to delete first 6 Digits and one Space from a CELL?
View Single Post
 
Old 08-03-2010, 11:17 AM
SmokingMan's Avatar
SmokingMan SmokingMan is offline Windows 7 Office 2007
Novice
  
Join Date: Aug 2010
Location: Indiana, USA
Posts: 5
SmokingMan is on a distinguished road
Default
Have you tried using "convert text to columns" using the space after the digits as a delimiter? You can use that to dump the unwanted data.
Last edited by SmokingMan; 08-03-2010 at 11:19 AM. Reason: Add to answer
Reply With Quote