CODEWITHSUNDEEP
excelopenoffice-calc
Exoon
Exoon

Reputation: 1553

Copy current text and change it

I have lots of URLs in an spreadsheet, I need upload it in the following format:

It is currently like this:

http://url.com/this_is_an_example
http://url.com/another_example

I need it like this:

http://url.com/this_is_an_example, http://url.com/this-is-an-example
http://url.com/another_example, , http://url.com/another-example

I know i can just use find & replace to replace _ with - but how can i copy the same url next to the exisiting one?

I'm using Openoffice Calc

Thanks

Upvotes: 0

Views: 38

Answers (1)

WorkSmarter
WorkSmarter

Reputation: 3808

The only difference between the two solutions is the delimiter used for the concatenate and substitute statements i.e. ";" vs ",".

Openoffice Solution:

=CONCATENATE(A1;", ";SUBSTITUTE(A1;"_";"-"))

Result

enter image description here

Excel Solution:

=CONCATENATE(A1,", ",SUBSTITUTE(A1,"_","-"))

Result enter image description here

I know i can just use find & replace to replace _ with - but how can i copy the same url next to the exisiting one?

In the end, you could hide the original column and leave the custom column.

Upvotes: 2

Related Questions