Splitting a multiplication formula

[shreeram.maroo]

Hi I have a excel list which consists of two row - let's say invoice number and amount
Under amount column - figures are manually punched and muliplied by a certain factor - it could be 0.9, 0.8, 0.88 or so on, there are multiple varitieis there.

I want to split the amount and factor in a separate column. Is there any way i can do i quikcly for all 20000 rows ?


Regards
Shreeram

[shreeram.maroo]

Tried using textsplit. But * doesn't works, i guess it is itself a wildcard :p

[HansV]

Could you attach a small sample workbook that demonstrates the problem?

[shreeram.maroo]

Hi Hans,

Attaching a sample file

[rory]

You need to access the formula, so - in G4:

=LET(ft,FORMULATEXT(C4),t,RIGHT(ft,LEN(ft)-1),TEXTSPLIT(t,"*")+0)

and copy down.

[shreeram.maroo]

Thanks a ton Hans, this was really really helpful and saved lot of time.

[StuartR]

Thanks a ton Hans, this was really really helpful and saved lot of time.

You might want to thank rory too

[shreeram.maroo]

Apologies, I am not very much active here. Didn't notice the reply was from Rory. Thanks a lot Rory.. sorry for noticing it after 7 long months :(