Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-01-2010, 11:33 PM
Learner7 Learner7 is offline How to delete first 6 Digits and one Space from a CELL? Windows XP How to delete first 6 Digits and one Space from a CELL? Office 2007
Advanced Beginner
How to delete first 6 Digits and one Space from a CELL?
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default How to delete first 6 Digits and one Space from a CELL?

Hi,

How to delete first 6 Digits and one Space from a CELL? The following is the example:

Querry:
500345 Royal Plastics Pvt. Ltd.

Result:
Royal Plastics Pvt. Ltd.

Thanks.
Reply With Quote
  #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
  #3  
Old 08-04-2010, 01:01 AM
Learner7 Learner7 is offline How to delete first 6 Digits and one Space from a CELL? Windows XP How to delete first 6 Digits and one Space from a CELL? Office 2007
Advanced Beginner
How to delete first 6 Digits and one Space from a CELL?
 
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
  #4  
Old 08-10-2010, 04:06 AM
nsv nsv is offline How to delete first 6 Digits and one Space from a CELL? Windows XP How to delete first 6 Digits and one Space from a CELL? Office 2003
Novice
 
Join Date: Jul 2010
Location: Denmark
Posts: 17
nsv is on a distinguished road
Default

If the space is missing or you do not have a reliable delimiter you can also use the MID-function:
Quote:
=MID(A1,8,50)
which takes the content of cell A1 from the 8th to the 50th character.

NSV
Reply With Quote
Reply

Thread Tools
Display Modes


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 01:56 AM.


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