Hello, I have a column with different bar codes scanned. Only FedEx has some 30 digits, so i need the formula that will look for 30 digits in a cell and copy past last 12 digits to the adjacent column…
Hello Community I created a form with multiple drop down options. I need to parse out those options so each one shows in a separate cell. I figured out the first one but cannot find the correct formul…
=JOINARRAY([End Delimiter],Range 1, [Range 1 Delimiter],...) *No delimiter for last range listed. =JOINARRAY(", ", A:A, " ", B:B) results in: x 1, y 2, z 3 blank values are ignored, hence the over-rid…