Hi there,

I have a list of numbers in a column in Excel that I need to copy into another cell using a formula. I know that I could do an easy =A2 formula, etc, but some of the cells with the data that I need copied have one number and others have two numbers from which I need to take the second.

Here's an example of the values in my column that I need to copy into another column:

100000000
150000000
50000000|19775000
2000000000
100000000
35000000
50000000

8000000000
200000000

For the cells with more than one number, I need to copy over the number that appears to the right of the "|" character. So essentially, I need a formula that would work regardless of whether the referenced cell contains one number (that number is populated into the new cell), more than one number (the number furthest to the right is copied into the new cell), or are blank (new cell would be blank)>

Any idea how to do this?