=index(ImportXml(https://www.google.com/finance?q=ibm, //div[@class = 'companySummary'] ),0,1)Put that anywhere in a Google sheet and it will give you a cell with a block of text. This text is in a paragraph form and takes up several lines. How do I use formulas to make it so the text is one line? It's possible because I can do it by hand if needed. I've tried:=join( ,split(A1, ))
How to recombine text into one line in Google Sheets
google spreadsheets
Short answerUse the following formula=SUBSTITUTE(A1,Char(10), )ExplanationIMPORTXML added line feed characters which ASCII code is 10. An alternative to the use of Char(10) is to add a breakline (CTRL + ENTER) and enclose it in quotes marks:=SUBSTITUTE(A1,, )