Copying Parts of Cells

[Henry1807]

Hi All,

I have an interesting problem. I have a few hundred records with cells that have slashes ("/") in them, and I'm trying to copy what's before and after the slashes into two different cells. For example:

1234/56 --> 1234 and 56
123456/7 --> 123456 and 7
etc. (I hope this is clear).

I've figured out how to check to see if a particular character is in a cell. But how do I tell Excel to copy what's before or after this character in the cell (in this case, the character being the slash).

Thanks.

Henry

 

[PaddyD]

Hi - select the column, go to data | text to columns. select delimited, click next, put the / as the delimiter (for the 'other' option), click next, sdelect a destination (if you want to preserve the original data), click finish

paddy

 

[Henry1807]

Hey PaddyD,

Worked like a dream. Thanks!

Henry