Hi All
I know how to insert characters x spaces from left or right, but in my column have a list of email addresses.They are all completely different and vary in length an characters before and after the @ sign.
As an example I would like to change fred@smith.com to fred-123@smith.com and john@doe.com to john-123@doe.com.
The text to insert will always be -123 and always immediately before the @ sign.
Can anyone help please? I don't fancy doing 300 manually
Thanks
I know how to insert characters x spaces from left or right, but in my column have a list of email addresses.They are all completely different and vary in length an characters before and after the @ sign.
As an example I would like to change fred@smith.com to fred-123@smith.com and john@doe.com to john-123@doe.com.
The text to insert will always be -123 and always immediately before the @ sign.
Can anyone help please? I don't fancy doing 300 manually
Thanks
