[Solved] Split cell value into 2 parts separated by a .

[Max1001]

I have spreadsheets with columns of domain names in columns.
I want to add columns to split
exampledomain.com
anotherdomain.net
yetanotherdomain.website
etc

into
exampledomain.com exampledomain com
anotherdomain.net anotherdomain net
yetanothername.website yetanothername website

etc.

I realise this can be done use copying and Text to Columns, but I need to be able to do this in a formula each time I add a new domain into the LH column.
There is no predictable length of either part before or after the . of course.

Formula to do this?

Thanks!

[FJCC]

If there is only one ., this will extract the text before the .

Code: Select all

=LEFT(A1;FIND(".";A1) -1 )

and this will extract the text after the .

Code: Select all

=RIGHT(A1;LEN(A1) - FIND(".";A1))

[Max1001]

Thanks very much. This worked a treat.

I should have said I needed to retain the . in the 2nd column, which I accomplished using Concatenate as follows:
=(CONCATENATE("."; RIGHT( $A1;LEN($A1)-FIND("."; $A1))))

[Bald Eagle]

I should have said I needed to retain the . in the 2nd column, which I accomplished using Concatenate as follows:
=(CONCATENATE("."; RIGHT( $A1;LEN($A1)-FIND("."; $A1))))

Or you could have used the "&" operator, or just adjusted the formula as follows to include that extra dot character.

RIGHT ( $A1; LEN($A1) - FIND("."; $A1) + 1 )

or

RIGHT ( $A1; LEN($A1) - (FIND("."; $A1) - 1) )

Always good to have backup methods