[Solved] Convert email to URL?

[jon oneill]

Hi, is there a way to convert a list of emails to urls in Calc?

joe@bloggs.com
to
http://www.bloggs.com

Thanks

[FJCC]

First, select all of the cells you want to affect. Using Edit -> Find & Replace, set Search For to
^[^@]+@
and set Replace With to
www.

Under More Options, choose Regular Expressions and Current Selection Only. Click Replace All and you should be done. I would definitely save a copy of the document in case you replace more than you mean to.

[jon oneill]

First, select all of the cells you want to affect. Using Edit -> Find & Replace, set Search For to
^[^@]+@
and set Replace With to
www.

Under More Options, choose Regular Expressions and Current Selection Only. Click Replace All and you should be done. I would definitely save a copy of the document in case you replace more than you mean to.

You have saved me loads of time! thanks a lot!

Couple of other quick questions if you have a second?

Now the urls are in the cells, is there a way to bulk convert them to clickable links? I know that pressing space after them in the cell does this, but is there a less manual way?

Also, bit of a long shot, but is there a way to select and move the email address from a cell to the adjacent cell?
Cell contains : "Joe Bloggs joe@bloggs.com"
Is there a way to split the name and address to two cells: "Joe Bloggs" | "joe@bloggs.com"

Thanks a lot

[robleyd]

Is there a way to split the name and address to two cells: "Joe Bloggs" | "joe@bloggs.com"

You could adapt the techniques proposed in How to find the last word in cell, copy to new cell or in Splitting Full Name into F|M|L

[Lupp]

(Not concerning the original question, but only the addendum.)

Recent versions of LibreOffice have the REGEX function which is useful with tasks of this kind.
See attached example. Note: The example will not work in AOO or old versions of LibO. It needs LibO V 6.2.y or higher.
See https://wiki.documentfoundation.org/Rel ... _functions

[John_Ha]

See [Tutorial] How to record a macro (and Regular Expressions) for help on Regular Expressions which are used to manipulate text strings.

[jon oneill]

Just gotta say thanks for all this, saving me a ton of time Really appreciate all your advice