Remove extra characters from a cell

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

This may be something simple, but does any one now how to
remove leading characters from a cell that was imported
from another system. The first 8 characters are zeros and
don't belong in my spreadsheet. Thanks in advance.
 
Hi
you could enter the following in a helper columne
=MID(A1,9,255)
and copy this down
 
Hi Ann,
If the cell has a non breaking space or even if it is
preceded by a single apostrophe to make it text the TRIMALL
macro will probably work for you
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Normally, I think, with leading zeros you'd want to retain them,
but in this case you don't so it actually works out for you.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How can I remove a non-printing character from a cell? 2
Math formulas possible with overstrike characters? 2
Formula to validate characters within a string of data in aparticular cell 1
Excel 2003, Linked Spreadsheet, Cell Character Count 3
Removing Special characters in Excel 8
Need to add character before leading zero in a field 7
check first 3 characters of a cell and compare to a table 4

Back
Top