I wonder if there is a way to extract a website address from within a text. noting that :
1- text field contains mix of email addresses and website address
2- email address can be before the website address or after it
3-some cells contain more than a mail address and a website address
4- there are no common separators between the email and website address. sometime "/" is used sometimes "-" and most of the times a space is a separator.
one way is using text to column separating columns by the above separators but it becomes a tedious approach as it requires multiple level of separation and filtering specially when data is very large.
another way could be using right, left or mid function but given the address is not always to right or left or even centre it is kind of difficult
i would appreciate if anyone can help
1- text field contains mix of email addresses and website address
2- email address can be before the website address or after it
3-some cells contain more than a mail address and a website address
4- there are no common separators between the email and website address. sometime "/" is used sometimes "-" and most of the times a space is a separator.
one way is using text to column separating columns by the above separators but it becomes a tedious approach as it requires multiple level of separation and filtering specially when data is very large.
another way could be using right, left or mid function but given the address is not always to right or left or even centre it is kind of difficult
i would appreciate if anyone can help