excel formatting

  Roland Butter 22:26 02 Jun 03

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 03

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


in Row 1 and copy the formula down.

  Roland Butter 22:37 02 Jun 03

Thanks VoG™

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

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Codename NX console…

1995-2015: How technology has changed the world in 20 years

8 things designers (and brands) need to know about the modern woman

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…