How to extract the text from a cell with formulas in it? Hello, I am running int

Question

How to extract the text from a cell with formulas in it?

Hello,

I am running into a problem that I need a little help with. I have a cell (A2) that includes text that has been generated using formulas. I want to automatically have the text only in a different cell (D2) so the user can simply copy and paste the text into a different program (See example). Is there a way to do this?

EG: (A2)

=CONCATENATE("Tier 1 - ", " ",$C$3,", ",$F$3,". ",$C$9," customer called to discuss ",$C$21, ". ")

After the reference cells are filled in the text reads:

Tier 1 - John Doe, 12345. Ohio customer called to discuss tires.

I want the above text in D2 so the user can just copy and paste into a different program (so they can't just paste values)

Thank you for your help !!

Explanation / Answer

Hi..

If you want it to be automatic:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Range("A2"), Target) Is Nothing Then
        Application.EnableEvents = False
        If Range("A2").Value = "" Then
            Range("D2").ClearContents
        Else
            Range("D2").Value = Range("A2").Value
        End If
        Application.EnableEvents = True
    End If
End Sub

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.