Andreamary
asked on
Tweaking a concatenated formula in Excel
I am using a simple formula in Column I to concatenate the values in Columns B, F, G & H and insert hyphens in between each string being concatenated. Sometimes there no values in Columns G & H, so the concatenated result ends up with a hyphen dangling at the end. Other times there are no values in B, F, G & H, in which case the concatenated results contains hyphens only. I would like to revise the formula to eliminate the dangling hyphen, and if there are no values, then have the cell remain blank.
I've attached a sample spreadsheet illustrating the existing formula + desired results.
Thanks!
Andrea
Sample-Concatenation.xlsm
I've attached a sample spreadsheet illustrating the existing formula + desired results.
Thanks!
Andrea
Sample-Concatenation.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome very much, Andrea. :-)
Glenn,
glad to see you back :-)
glad to see you back :-)
ASKER
Andrea