Chop number of characters in a cell

[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

 

[Andy B]

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

 

[Mary E. Hill]

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

Aaahhh - genius's - THANKS!

 

[Guest]

=left(cell location,numberofcharacters)
for details, lookup in help