Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 08-03-2010, 11:17 AM
SmokingMan's Avatar
SmokingMan SmokingMan is offline How to delete first 6 Digits and one Space from a CELL? Windows 7 How to delete first 6 Digits and one Space from a CELL? 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to delete first 6 Digits and one Space from a CELL? autocorrect double space to single space frankjake Word 8 09-21-2018 05:44 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM
How can I make a cell color RED under the Today's date cell? Learner7 Excel 2 07-08-2010 12:52 AM
How to delete first 6 Digits and one Space from a CELL? double space sussertown Excel 1 04-06-2009 07:47 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft