Forum Discussion
mandipkhanal10
May 22, 2023Copper Contributor
multiplication in a column having asterisk separated value.
how to multiply the values of a column if there is asterisk symbol between the values in a gomultiply these columns in a go
Enter = in front of the values.
- mtarlerSilver Contributor
alternatively use:
=PRODUCT(--TEXTSPLIT(A1,"*"))
in column next to it and fill down