Thread: Excel ??
View Single Post
  #5   Report Post  
JulieD
 
Posts: n/a
Default

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.