Hi
one way is to use a helper column - e.g. with your data starting in A1,
type in B1
=LEFT(A1,15)
and then move your mouse over the bottom right hand corner of B1 until you
see a + then double click - this will fill the formula down the column - now
select column B and copy, click on cell A1 and choose edit / paste special -
values
column B can now be deleted.
If you don't want to use a "helper" column - you can achieve what you want
using code - please post back if you'ld like information on how to do this.
Cheers
JulieD
"Iservthee" wrote in message
...
I want to keep the first 15 characters in a column and delete everything
after those characters.
|