i have text like this
+55056 active Aug. 20, 2018 492 commentsonbannna
+52206 active Aug. 20, 2018 796 commentsonapples
+36475 active Aug. 20, 2018 1008 commentsonpears
now i was trying and failing to create a expression to delete from + all the way to comments leaving the rest out, i can use normal replace to delete (active Aug. 20, 2018) & (1008 comments)which leaves me on just +36475 onpears which i can also do and delete just the (+#####). mainly i’m just trying to get rid of the +00000 but i’m doing large spreadsheet so it would take me a few weeks by hand.
any help will be appreciated and thanks.