How do I implement =SUBSTITUTE(A1,CHAR(10),” “) when the cell containing the data and line breaks is cell G1? Where would I put the actual formula for this to work? A sample spreadsheet is attached. Assistance is greatly appreciated.
From novice to tech pro — start learning today.