Cell Formatting Question

[jdssailing]

Good Evening All!

I have a CSV file that I use to update an 8000 item database for upload to my product database. The process involves me manipulating the formatting of our primary database that we receive from our supplier to a format which our websites CSV upload uses. I'm attempting to use the replace function to create a change to a range of cells. Below is an example of what I'm attempting to do.

These are the values in the original database:

12345| 12345| 12345| 12345

I'm trying to use the replace function to create:

12345,12345,12345,12345

But when I go to replace "| " with "," the cells format into:

12,345,123,451,234,512,345

I've been playing with the different format options but can't seem to find a fix... any advice for a first time poster would be greatly appreciated!

[RudiS]

Hi,

It will be better to use this function: =SUBSTITUTE(A1,"| ",",")