Splitting data in Cells

Hi Everyone,

I have a load of cells that contain email addresses, and i need to split these addresses down, to show only the domain names.

Is there a quick way of doing this, or do i need to click into every cell and delete the 1st half of the address?

Many Thanks

James

Hi Everyone,

I have a load of cells that contain email addresses, and i need to split these addresses down, to show only the domain names.

Is there a quick way of doing this, or do i need to click into every cell and delete the 1st half of the address?

Many Thanks

James

James try text to column option in data tools to split the cells.

tek9step

Hi james_edstrom
try...

Please Login or Register  to view this content.

adjust ranges to suit

Hi,

How about this:

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

or use data > text to columns > delimited > custom > @

oopsie, there's some double posting going on. Mods, please merge?

oopsie, there's some double posting going on. Mods, please merge?

Thanks everyone, very helpful!

James, if this solved your problem, please mark this thread and your other, double posted thread as solved, so people will no longer feel they have to find a solution. Then, before you post more, read the forum rules again.