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?

08-04-2010, 01:01 AM

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

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.

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:28 PM.