char(10)

Hi, I was able to return multiple values into one cell; however, I am trying to figure out how to change my delimiter from"," to Char(10): For i = 0 To DEPListBox.ListCount - 1 If DEPListBox.Selected(i) Then 'If selected is True strTemp = strTemp &...

Hello, I have a problem. I'm scrapping information from internet but when I place this info into cell It has a lot of break lines <tbody> " MLS Number Category Status Status Date Price 7068423 RES Temporarily Off Market 11/14/17 $150,000 6735873 RES...

Dear all, I've been using the website for long time now, always finding the resources I needed to keep on building my sheets. However I have been struggling with the following for a few hours, and can't find a proper answer, anywhere, so far... Situation: I have a whole sheet of numbers, used...

Hi everyone, I'm currently working on a PowerPivot where I'm trying to extract the position of a new line/carriage return in a cell containing text. In Excel, this is fairly straightforward using the CHAR() function, where CHAR(10) = line feed: =FIND(CHAR(10), <cell with text>) However, there...

Hi All, I need a formula to insert a line break after every 42 characters in a cell , example if there is 266 characters in a cell there should be 6(266/42)line breaks. =REPLACE(REPLACE(A1,42,0,CHAR(10)),84,0,CHAR(10)) I tried this but i am not sure how to get the start num to change to...

I have a worksheet in which a cell has 4 lines of data. Each bit of data is put on a new line within the cell using CHAR(10). Sometimes only 2 of the lines are TRUE and therefore only 2 text lines appear within the cell. However, the CHAR(10) function still inserts line breaks between the...