Forum Discussion
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 go
Enter = in front of the values.
alternatively use:
=PRODUCT(--TEXTSPLIT(A1,"*"))
in column next to it and fill down