THIS SOUNDS LIKE IT MAKES SENSE & SHOULD WORK, BUT WHEN I TRY IT THE CELL
ONLY SHOWS THE FORMULA I INPUT (EG. IN B2, ="W"&A2) INTO THE CELL & DOESN'T
PERFORM THE FUNCTION.
THANX!

"vezerid" wrote:

In a cell next to your number (say A1 has the number, so in B1),

="A"&A1 (or whatever letter you want inside the quotes)

If you want to get rid of the formulas, select the column, Edit|Copy
and then Edit|Paste Special... checking Values.

HTH
Kostis Vezerides