char10

Im trying to convert a list of data into a block of text which I will then paste into a word document. This formula will work, but I end up copying loads of blank cells/rows: =C2 & CHAR(10) & CHAR(10) & C3 & CHAR(10) & CHAR(10) ... ect Ive tried using this which fails when it hits a blank...

I am trying to concatenate as follows If F2 is not null, Concatenate F1 (header) and F2 CHAR(10) Else nothing If G2 is not null, Concatenate G1 (header) and G2 CHAR(!0) Else nothing If H2 is not null, Concatenate H1 (header) and H2 CHAR(10) Else nothing This formula works but I can use help to...

Thank you for your help, I understand the break lines now are char(10) and ctrl-J So if i have in one cell the following <tbody> John Smith 123 Main street Mycity, 123445555 </tbody> So if I want name and address and city in different columns then I use text-2-columns and the delimiter is...

hi folks, I get a daily file that has Alpha/Numeric content. to separate various entries, the originators add Char(10), at times two of them. looking for a formula that will find the second, fourth, sixth, eights, etc. Char(10) and replace it with "". it should not return an error is there...

Hello All- I have been trying to expand my excel skills but I have yet to learn VBA Code. Below is my concatenation and I am trying to bold all H$1,": ", ,I$1,": "..... through Q$1,": " =CONCATENATE(H$1,": ",H2,CHAR(10),I$1,": ",I2,CHAR(10),J$1,": ",J2,CHAR(10),K$1,": ",K2,CHAR(10),L$1,"...

My desire is to return all sequences of non-alpha characters from a range and seperate them by char(10) so they are a list. My intention with char(10) is that I would basically like to be able to return all such non-alpha sequences into a column where each result is in a single cell. If that can...