Concatenate Function Modification
I'm looking for help in modifying the concatenate function below to add "and" before the last string in the function. Currently, using the function on a selected range returns cell values strung together by ", " // For example: CellA, CellB, CellC.
I am trying to figure out how to modify the function so it will return the following: CellA, CellB, and CellC. Any help is much appreciated!
Please Login or Register to view this content.
try this
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi humdingaling! Thanks for your response and solution. It is working, but I have 2 more contingencies I'm hoping you could help me add to this function:
1. If the number of cells being concatenated is EQUAL to 1, then return the cell value as it is (no separator)
2. If the number of cells being concatenated is EQUAL to 2, then return "and" between the two cell values (EX: Christy and Diane)
Everything else is working great as long as there are 3 cells or more that are being concatenated. I've tried modifying your code above, but haven't been able to achieve what I described. Your help is once again greatly appreciated!
are you talking accounting for blank cells?1. If the number of cells being concatenated is EQUAL to 1, then return the cell value as it is (no separator)
as in if your range is 3 but only 1 has data?
the UDF already does this?2. If the number of cells being concatenated is EQUAL to 2, then return "and" between the two cell values (EX: Christy and Diane)
amended code to deal with too many blanks
replace your case zero with something else you wantPlease Login or Register to view this content.
just blank maybe?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks