Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In building a string based on THREE (or FOUR maybe in the future) columns
using CONCATENATE I am putting a "+" between each columns values. Problem is that sometimes a value is blank, and therefore I don't want extra "+" in the result. Please help me get "I Want" string results without a hideous nested if statement. It is acceptable to add columns which store interim values to help build string-- this is not a seen workbook. The "I Want" values ultimately go into a Pivot table along with some other columns. COL A COL B COL C My Result I Want OK? ------- ------- ------- --------------------- --------------------- ----- RED WHITE BLUE RED+WHITE+BLUE RED+WHITE+BLUE Y RED WHITE RED+WHITE+ RED+WHITE N +WHITE+ WHITE N RED RED++ RED N |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Concatenation | Excel Discussion (Misc queries) | |||
Concatenation | Excel Worksheet Functions | |||
Help with Concatenation | Excel Worksheet Functions | |||
Concatenation | Excel Worksheet Functions | |||
Concatenation | Excel Discussion (Misc queries) |