Formula to remove few leter from email adress

[dobracik]

HI all,

I just wanted to ask, if here is somebody who could help me to remove few characters from email address ?

I have a lot list which is quite time consuming to do it manually :-D

if I have address [email protected] what I need is to remove "-1" in the end. Each email could have more letters to be removed, but in the end I need the addresses only :-)

Thanks

[63falcondude]

If there are no hyphens within the email address, you can use Find and Replace.

Highlight the column > Find & Select > Replace

Find what: -*
Replace with: (leave blank)

[dobracik]

I would prefer to have it in function as Id like to add it into macro code as there might be more digits to me removed :-(

[63falcondude]

Oops, sorry, I missed the word "formula" in the title.

Try
=LEFT(A1,FIND("-",A1)-1)

[AlKey]

Try this
Enter in B1 and copy down

Please Login or Register  to view this content.

Or this

Please Login or Register  to view this content.

Both formula don't care for how may characters after the last dash. It will remove them all.

v	A	B
1	[email protected]	[email protected]
2	[email protected]	[email protected]