How to delete first 6 Digits and one Space from a CELL?

		Microsoft Office Forums > Microsoft Excel > Excel
How to delete first 6 Digits and one Space from a CELL?

FAQ

Thread Tools

Display Modes

08-01-2010, 11:33 PM

Learner7

Windows XP How to delete first 6 Digits and one Space from a CELL?

Office 2007

Advanced Beginner

Join Date: May 2010

Posts: 51

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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 04:33 PM.