Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I have text data that is combined from multiple fields. The values need commas between them, which I have added. However, some of the fields are blank and the result yields multiple commas in a row. I am using Replace to remove multiple commas in a row. However, I need to remove any leading or trailing commas as well. First image below is script to combine the fields. Second image is the replace function. Third is the output before and after the replace function.
Try As below
=Mid(Replace(field,',,',''),2)
Thanks! However, this does not work. It drops the leading comma and the first character of the next field because of the 2. It also leaves in tact all the multiple commas I want to remove. Here is the result when I try Mid(Replace....)