| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OMIT BLANK LINES WHEN FORCING A CARRIAGE RETURN --- PLEASE HELP!
The formula below works but I would like to omit lines that are blank.
i.e. =CONCATENATE(I15,CHAR(10),J15,CHAR(10),K15,CHAR(10 ),L15,CHAR(10),M15,CHAR(10),N15,CHAR(10),O15) Say line K15, L15 and M15 had no data like this : I 227 Finney Lane J Heald Green K L M N Cheadle O SK8 3QB How can I tell it to omit the blank lines, K,L,M so the address is without blanks? Your help would be much appreciated. Thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I omit a blank cell from a calculation?? | Excel Worksheet Functions | |||
| Carriage Return | Excel Worksheet Functions | |||
| Omit blank cells from function results | Excel Worksheet Functions | |||
| Macro to omit blank cells needed | Excel Worksheet Functions | |||
| How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
Threaded Mode
