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

Learner7 · #1 08-01-2010, 11:33 PM

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.

SmokingMan · #2 08-03-2010, 11:17 AM

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.

Learner7 · #3 08-04-2010, 01:01 AM

Quote:

Originally Posted by SmokingMan

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.

nsv · #4 08-10-2010, 04:06 AM

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

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