Microsoft Office Forums - View Single Post - How to delete first 6 Digits and one Space from a CELL?

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

View Single Post

Old

08-01-2010, 11:33 PM

Learner7

Learner7 is offline

Learner7 uses Windows XP

Windows XP Learner7 uses Office 2007

Learner7 uses Office 2007

Office 2007

Advanced Beginner

The original poster

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