Assuming numbers in A1 down
Try in B1: =LEFT(TRIM(A1),4)+0
Copy down
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Gordon Baxter" wrote in message
...
I have a column of numbers which I have imported from a website into a
spreadsheet.

Each cell has up to 8 characters. I want to discard everything but say
the
first 4 chararcters.

Can this be done?

Gordon