String Theory

April 2, 2009 4:46 PM

Excel-Fu Filter: How to display the value of one cell in the middle of a string in another cell. (Example inside)

Putting together a document template in Excel. Let's say cell A1 carries the value "UserName." I want cell B1 to have the value "Good day, [a1]. How ya doin'?"

Such that if A1="John," B1 will = "Good day, John. How ya doin'?"

Thanks, MeFi, for the help!

posted by bluejayway to Computers & Internet (4 answers total)

"Good day, "&A1&" How ya doin'?"
posted by Nanukthedog at 4:47 PM on April 2, 2009

B1 = "Good day, " & A1 & ". How ya doin'?"
posted by Simon Barclay at 4:49 PM on April 2, 2009

Best answer: =CONCATENATE("Good day, ", A1, " How ya doin'?")
posted by sbutler at 4:50 PM on April 2, 2009 [1 favorite]

Response by poster: You guys rock! Thanks.
posted by bluejayway at 4:56 PM on April 2, 2009