Merge 2 column to one with | seperator

-- HikaShop version -- : 3.2.0

Hi,

I need to import product prices separated with a | (pipe). I'm no expert in Excel.

I got two columns with prices.

An example:

Column A: 12,85
Column B: 15,55

I need this:

One column C: 12,85|15,55

How can this be done? I tried: C=A1&"|"&B1 but that's doesn't work.

Kind regards René

Hello,

(please understand that your question is not related to HikaShop or our support ; it's beyond the limit of what we can provide).

I would recommend you to add a column between the two prices and insert a unique content (a symbol you do not use, like # ).
Then export your content in CSV and thanks to a text editor, replace the separators and the # by your |

Regards,