PDA

View Full Version : copy cells with just text not the formulas



bgcarver
07-01-2015, 09:17 AM
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
07-01-2015, 11:09 AM
Sheet2.Range("A1").Value = Sheet1.Range("A1").Value

SamT
07-01-2015, 11:53 AM
Manually = Copy cells in one workbook, in another PasteSpecial >> Values.