Data Cleaning - What is the best method?

I'm new and struggling. I am trying to data cleanse columns of data that say 'USA-Senior Associate' and 'USA-Competency' and I would like to remove the 'USA-' from both sets. How do I do this?

Thanks

Tips and Tricks

Accepted answers

MarqueeCrew

@BenMoss,

Windex! Get something to clean those glasses.

Replace([_CurrentField], "USA-", '')

What could be easier than this formula (which by the way will work nicely in a multi-field formula tool.

Cheers,

Mark

All comments

BenMoss

A few options here but I'd go with the simplest in my eyes which would be to use the text to columns with a - delimiter.

Ben

MarqueeCrew

@BenMoss,

Windex! Get something to clean those glasses.

Replace([_CurrentField], "USA-", '')

What could be easier than this formula (which by the way will work nicely in a multi-field formula tool.

Cheers,

Mark

The_Data_Loop

You could also simply pad the first 4 characters out.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335