Parsing

copy paste last 12 digits from the specific cell
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. I know how to use the "RIGHT" formula, but dont know how to tell it only for the cells containig 30 digits. thasnk a lot!
How to parse out drop down selections into separate cells
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 formula for the second, third cells, etc. Any help is appreciated. Below is the formula i used to parse out the first item (thanks…
JOINARRAY() function Idea
=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-ride for the end of the item delimiter

Discussion List