Thread: How to delete first 6 Digits and one Space from a CELL?
View Single Post
 
Old 08-04-2010, 01:01 AM
Learner7 Learner7 is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default
Quote:
Originally Posted by SmokingMan View Post
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.

Thanks for the help. It's quite nice and easy.
Reply With Quote