copy cells with just text not the formulas

[bgcarver]

How can I copy text from cells from one worksheet to another. I have one worksheet that I have formulas for separating out first and last name. I want to copy that result to another worksheet as text into another worksheet. I just need the resultant text copied.

TIA

[Kenneth Hobs]

Sheet2.Range("A1").Value = Sheet1.Range("A1").Value

[SamT]

Manually = Copy cells in one workbook, in another PasteSpecial >> Values.