Grabbing text from a cell to use in a sentence in another cell - Google Sheets

Viewed 26842

On Google Sheets, I'm trying to use the text in one cell (say B4 contains: "Janet") and reference it in a sentence in another cell (say G4 is: "Hi {Enter B4 here}, I'm reaching out to you today...")

A little background: I have about 130 columns of data that contain websites, first name, email, and vendor type that I hope to reference in an out reach email that I just copy down across a series of columns.

Thanks for any help

2 Answers
Related