multiplication in a column having asterisk separated value.

Copper Contributor

how to multiply the values of a column if there is asterisk symbol between the values in a gomultiply these columns in a gomultiply these columns in a go

2 Replies

@mandipkhanal10 

Enter = in front of the values.

alternatively use:
=PRODUCT(--TEXTSPLIT(A1,"*"))
in column next to it and fill down