Data Cleansing Hyphen

mustufa2019

I am trying to perform data cleansing and remove hyphen between names and remove the spaces. See below example:

Input:

First Name	Last Name
Jack	Smith-Owen
David	Flintoff
Andrew	Lehman-Smith
Ahmed	Abdul-Karim

Output:

First Name	Last Name
Jack	SmithOwen
David	Flintoff
Andrew	LehmanSmith
Ahmed	AbdulKarim

BrandonB

You can do this using a formula tool. Set the field to Last Name

Replace([Last Name], "-", "")