| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing Mulitple Carriage Returns Within a Concantenate Formula
Hi,
Having used concantenate to combine cells with a char(10) in between the cell contents, I now face the problem of multiple carriage returns where there were empty cells. Is there a formula which will enable me to avoid this problem or now rectify it? Thanks, Jane |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: How to insert carriage returns in a formula to manipulate t | Excel Worksheet Functions | |||
| Removing carriage returns from excel | Excel Worksheet Functions | |||
| Formula for Carriage Returns | Excel Discussion (Misc queries) | |||
| Carriage returns in the formula bar? | Excel Worksheet Functions | |||
| Removing Carriage Returns in Excel 2000 | Excel Discussion (Misc queries) | |||
Threaded Mode
