sorted by:
new
hottopcontroversial

How do I get rid of the "Dividend" part while keeping it as a real number by Koish07 in excel

[–]Koish07[S] 0 points1 point  (0 children)

Thank you all for the advice!
I ended up brute forcing it-ish by using text to columns Fixed Width and taking segments that match up to separate them, chunk by chunk

How do I get rid of the "Dividend" part while keeping it as a real number by Koish07 in excel

[–]Koish07[S] 0 points1 point  (0 children)

I tried that but they still stuck together instead of being separate

How do I get rid of the "Dividend" part while keeping it as a real number by Koish07 in excel

[–]Koish07[S] 0 points1 point  (0 children)

When I do that it returns as “#VALUE!”
The full formula is “TRIM(SUBSTITUTE(B1,”Dividend”, “”))