Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I have a number of columns - some have values and some don't. I wish to append only the columns with values and have comma separators. Is there an easy way to do this? Currently, I do this in 4 steps but I'm hoping there is an easier way. 1) Column EQ has a formula to append values in columns R thru Z 2) Column ER looks at EQ and substitutes " ," with blanks. Unfortunately ER always ends with ", " PLUS if only one column has any values, then ER also starts with " ," So to fix this, I do 2 more steps: 3) Column ES looks at ER to remove any values starting with ", " 4) Column ET looks at ES to remove ", " at the end Thanking you in advance for any help you can provide. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Remove text values from graphs | Excel Discussion (Misc queries) | |||
how can I Append values to an existing excel file. | New Users to Excel | |||
Append text | Excel Discussion (Misc queries) | |||
Append Text to Cell Values Using Replace | Excel Discussion (Misc queries) | |||
Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) |