May 22 2023 11:33 AM
how to multiply the values of a column if there is asterisk symbol between the values in a gomultiply these columns in a go
May 22 2023 11:44 AM
Enter = in front of the values.
May 22 2023 12:54 PM - edited May 22 2023 12:58 PM
alternatively use:
=PRODUCT(--TEXTSPLIT(A1,"*"))
in column next to it and fill down