Chop number of characters in a cell

  • Thread starter Thread starter Mary E. Hill
  • Start date Start date
M

Mary E. Hill

Hi, everyone! I hope we have some geniuses out there who can help me;)

I've got a column with 30,000 cells in it and I need to limit the number of
characters per cell to 15. The data present is sometimes longer than 15
characters and sometimes shorter.

I want the characters at the end of the string to drop off.

I'm sure there is some way to do this, but haven't a clue myself.

Can anyone help?

Thanks SO much for reading...

Mary
 
Mary

Use a helper column alongside your existing column. Type

=LEFT(A2,15)

in B2 and then fill down your column to autofill the formula down.
This returns the first 15 characters of A2, If you want to place that actual
value into the cell, select the column, Copy, Paste Special and select
Values.

Andy
 
Andy B said:
Mary

Use a helper column alongside your existing column. Type

=LEFT(A2,15)

in B2 and then fill down your column to autofill the formula down.
This returns the first 15 characters of A2, If you want to place that actual
value into the cell, select the column, Copy, Paste Special and select
Values.

Andy
Click to expand...

Aaahhh - genius's - THANKS!
 
Back
Top