Hi

Try
=A2&IF(A2<"","¦","")&A2&IF(A2<"","|","")&B2&IF( B2<"","¦","")
&B2&IF(B2<"","|","")&C2&IF(C2<"","¦","")&C2&IF( C2<"","|","")

--

Regards
Roger Govier

"Excel Helps" wrote in message
...
I have a list of products that have different options, that will be
displayed
on a website with various dropdown menus.
The menus are created from a CSV Import file that is itself created from a
large excel file simaler to this example:

RED WHITE BLUE
red white blue
red blue
white


red¦red|white¦white|blue¦blue|
red¦red|¦|blue¦blue|
¦|white¦white|¦|
¦|¦|¦|

The function to achieve the seperated pipes is:
=A2&"¦"&A2&"|"&B2&"¦"&B2&"|"&C2&"¦"&C2&"|"
My question is, what do I need to add to the function to NOT DISPLAY THE
PIPES WHEN THE CELL CONTAINS NO DATE.
At the moment, with my function, even if the cell contains no data I still
have the Pipes displayed which I don't want, I need just empty cells.