Excel ??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to keep the first 15 characters in a column and delete everything
after those characters.
 
have you tried?
=left(a2,15)
or
Sub leftif()
For Each c In Selection
c.Value = Left(c, 5)
Next
 
If youre data starts in range A2 then enter formula =left(a2,15) in cell B2
and fill down.
 
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
 
Another way........

Select the column.....do Data > Text to columns > Fixed > and set a column
line where you want the break > then select the undesired columns and tick
"Do not import column"

Vaya con Dios,
Chuck, CABGx3
 
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
Lower-Case Characters 2
Asterix, how to replace it? 2
Excel Help creating Excel formula 1
Count first and last characters 3
FIND 2nd character in a string 5
Extracting certain characters from a long string 4
countif / sumif function error 3

Back
Top