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
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