Simple question I hope....

  • Thread starter Thread starter 3steps
  • Start date Start date
3

3steps

I have a worksheet that has a column with the fields
filled with 000009620300000058718030916 or very similar
numbers....I would like to take 6 digits off the end of
the number and ten off the front, so it would be
00000058718. I think this could be done easliy, but I'm
not very good with Excel. Any help is appreciated.

Thanks
3steps
 
3steps,

If your numbers always have 27 digits it's
=MID(C15,11,11) OR if the lengths can vary but you
always want 10 removed from the front and 6 from the
back
=MID(C15,11,LEN(C15)-16)

Dan E
 
If the data is all the same width, then select the data and do Data / Text To Columns / Fixed
Width. Set breaks between the 10th and 11th digits and also between the next break you want
depending on how many digits there are. This gives you 3 columns of digits, so select the first
and choose 'Do Not Import Column', and same for the 3rd column.
 
Back
Top