Adding double pipes between spaces in a cell

[ExcelFormulas]

Does anyone have an Excel UDF that takes data with spaces and converts to the double pipe format?



The example the dspace wiki gives is (
https://wiki.duraspace.org/display/D...data+Editing):
Horses||Dogs||Cats

I need to do the same thing for bounding data that looks like:
-56.4343 23.4545 67.4309 54.322

To

-56.4343 || 23.4545 || 67.4309 || 54.322



Thanks

Bob

[shg]

Have you tried Ctrl+H (Find & Replace)?

[ExcelFormulas]

They are all different values. Like 200 different cells with different bounding coordinates. It would be a nightmare to do by hand.

[shg]

I don't know what "bounding coordinates" means. I was suggesting that you replace " " with " || ", sans quotes.