ExcelBanter - Convert formula result to string

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Convert formula result to string (https://www.excelbanter.com/excel-discussion-misc-queries/228780-convert-formula-result-string.html)

dennis

Convert formula result to string

How will I convert formula results to string?

e.g.

E11 | F11 | G11
MgCPDCEOPR|MgCPDCEOPR|=E11&".master = "&F11

G11 returns "MgCPDCEOPR.master = MgCPDCEOPR" -- I want this string to be
tangible.
--
===================================

Jacob Skaria

Convert formula result to string

Copy ..Rightclick..Paste Special..Values..OK
--
If this post helps click Yes
---------------
Jacob Skaria

"Dennis" wrote:

How will I convert formula results to string?

e.g.

E11 | F11 | G11
MgCPDCEOPR|MgCPDCEOPR|=E11&".master = "&F11

G11 returns "MgCPDCEOPR.master = MgCPDCEOPR" -- I want this string to be
tangible.
--
===================================

All times are GMT +1. The time now is 02:36 PM.