uncleslinky
New Member
- Joined
- Mar 31, 2009
- Messages
- 47
Hi guys,
I have a multiple numbers in a cell which I need to split into seperate cells.
For example, in A1 I have: 4-1 (0-1)
I would like to split this so each number is in it's own cell...
B1 - 4
C1 - 1
D1 - 0
E1 - 1
In this example each number is a single digit however numbers may sometimes be two digits and therefore I wasn't able to find a simple way using just 'left' or 'right'.
I've been experimenting with "find" to locate the position of "-" and "(" but so far I'm a little stumped on what to do next. To extract the first number I've come up with:
=LEFT(A1,FIND("-",A1)-1)
This seems to extract the number and the -1 removes the hyphen but I'm having trouble working on the other numbers. Any ideas? :D
Thanks
I have a multiple numbers in a cell which I need to split into seperate cells.
For example, in A1 I have: 4-1 (0-1)
I would like to split this so each number is in it's own cell...
B1 - 4
C1 - 1
D1 - 0
E1 - 1
In this example each number is a single digit however numbers may sometimes be two digits and therefore I wasn't able to find a simple way using just 'left' or 'right'.
I've been experimenting with "find" to locate the position of "-" and "(" but so far I'm a little stumped on what to do next. To extract the first number I've come up with:
=LEFT(A1,FIND("-",A1)-1)
This seems to extract the number and the -1 removes the hyphen but I'm having trouble working on the other numbers. Any ideas? :D
Thanks