IF first letter in name starts with A, then put an Abc

Edit: It's been a while since I've used Office 2007. If memory serves me correctly you may need to array enter this formula in B1 and copy down.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Try this and copy down.

Formula:

Please Login or Register  to view this content.

Or depending upon how I interpret the intent (also array entered)

Formula:

Please Login or Register  to view this content.