displaying part of a cell contents

[erikwvb]

I have a column of cells that contain 3 letters followed by series of periods. I'd like to display only the 3 letters. i.e.

ABC..... ABC
ABC..... ABC

Thanks

[martindwilson]

find replace . with blank maybe

[Paul]

Hi Erikwvb,

If you need to do it in the same column (replacing the values), just use the Find/Replace dialog. If you want to have the values in other cells, you can use the LEFT function, e.g.

=LEFT(A1,3)

[erikwvb]

Thanks!

I knew it would be something simple like that. I just couldn't remember