Try typing in =F1 into the cell press enter.
Maybe this will work

"famdamly" wrote:


I need a formula to reside in cell F1 that simply extracts only the text
and not the numbers from cell A1 The value in A1 should remain
unchanged. I know this is too easy. I should be able to look this one
up, but my brain is fried.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=516690