Problem with Cells

  • Thread starter Thread starter Blacklab
  • Start date Start date
B

Blacklab

Hope someone can help with this after downloading a small excel file from a
dealer site that is a genereated report, I can download it as an excel
file, upon doing so and pasting it into my working sheet I end upwith this
ÿ
at the end of the text in every cell, and when it is removed some cells
change for example a cell which has a long number for a serial number will
shorten as well
where do I start
the excel version is 2000
(e-mail address removed)
remove no spam
 
Try this:
1)Select the range with the serial numbers you want to clean.
2)Set the numeric format for those cells to Text
Format>Cells>Number>Category>Text
3)Remove the offending trailing characters

Does that help?
 
Back
Top