Text Extraction

[newbie13]

Hi,

I'm looking to separate the text in a cell.

say if i have; aaa@a.co.uk I just want the "a.co.uk" part of the string (everything after the @ symbol)

Any idea's people?

Help is appreciated.

Newbie13.

[arthurbr]

Hi, try =RIGHT(TRIM(C9);LEN(C9)-FIND("@";C9;1)) if your value is in C9 ( replace ; with , if necessary)

[newbie13]

Thank you very much.

I'd just worked it out actually. But the way you have described is much more efficient.

Many thanks!

[Marshall101]

=RIGHT(A1,LEN(A1)-FIND("@",A1,1))

You address would be in A1

[arthurbr]

Newbie,
if this solves your problem, don't forget to change your title's prefix to " solved"
Thx