excel formatting

  Roland Butter 22:26 02 Jun 2003
Locked

in an excel worksheet with a column full of first names, does anyone know how to apply some formatting that will make excel display just the first letter of the name, without going through and modifying each and every entry?

  VoG™ 22:30 02 Jun 2003

Create a new column. Let's say your first names are in column A. In the new column enter

=LEFT(A1,1)

in Row 1 and copy the formula down.

  Roland Butter 22:37 02 Jun 2003

Thanks VoG™

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

8 brilliant character artists speaking at Pictoplasma 2018

iMac Pro release date, UK price & specs

Football : comment regarder la Ligue 1 en direct ?