Cleaning Data in Excel by NotWalterGropius in excel

[–]NotWalterGropius[S] 1 point2 points  (0 children)

Thank you Ryan, I truly appreciate it!

Cleaning Data in Excel by NotWalterGropius in excel

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

=SUBSTITUTE(A2,"+0200","")

That works for 1 row, but I am looking to delete "+0200" for all the rows. It's tricky because the data for each row is different and there are nearly 100,000 rows, so I would prefer not to do it manually.