Multiplying out cells with text

[jimbo123]

Hi,

I am trying to multiply out cells that contain text. Initially the cell value in cell G24 was '6*13+16*17+6*1. But I have removed the '.
All cells in the column can vary in their multiplication,
e.g. 6*13+16*17+6*1
e.g 2*11+1

Do you know how i can turn this into a multiplication in the cell beside that will put brackets around each multiplication?
e.g. I would like my above example to return =(6*13)+(16*17)+(6*1) and =(2*11)+1

Any help would be greatly appreciated.

Best,
Jim

 

[saboh12617]

Hello,

On Excel 365/for the web, you could have gone with a formula like this

=REDUCE(0, TEXTSPLIT(G24, "+"), LAMBDA(acc, v, SUM(acc, PRODUCT(VALUE(TEXTSPLIT(v, "*"))))))

However on Excel 2021 I think you need to go with VBA/PQ since there is no TEXTSPLIT function.

 

[Fluff]

Hi & welcome to MrExcel.
Not quite what you wanted, but how about

Fluff.xlsm
	G	H
24	6*13+16*17+6*1	=(6*13)+(16*17)+(6*1)
25	2*11+1	=(2*11)+(1)
Data

Cell Formulas
Range	Formula
H24:H25	H24	="=("&SUBSTITUTE(G24,"+",")+(")&")"

 

[jimbo123]

Hello,

On Excel 365/for the web, you could have gone with a formula like this

=REDUCE(0, TEXTSPLIT(G24, "+"), LAMBDA(acc, v, SUM(acc, PRODUCT(VALUE(TEXTSPLIT(v, "*"))))))

However on Excel 2021 I think you need to go with VBA/PQ since there is no TEXTSPLIT function.

Thanks saboh!

I was wrong about my version of excel, this worked a treat!

Best,
Jim

 

[saboh12617]

Glad to help. Have a good day.

 

[Fluff]

I was wrong about my version of excel

Then I suggest you update your profile with the correct version.

I thought you wanted the result to be like =(6*13)+(16*17)+(6*1) rather than do the maths.

 

[jimbo123]

Thanks Fluff, have updated profile now!