Willy_B_Jones
New Member
- Joined
- Jun 16, 2008
- Messages
- 4
I have a list of persons names that i have imported into excel.
The problem is that they are in the format ...
jones/willy
bloggs/joe/billy
... and each string above is in one cell.
Can i write a macro to look at each character in the string and stop when it finds the value "/" and then cut the remainder of the string and write it to another cell.
Essentially i am trying to separate the surname and forenames into their own cells and any help on this would be gratefully received.
The problem is that they are in the format ...
jones/willy
bloggs/joe/billy
... and each string above is in one cell.
Can i write a macro to look at each character in the string and stop when it finds the value "/" and then cut the remainder of the string and write it to another cell.
Essentially i am trying to separate the surname and forenames into their own cells and any help on this would be gratefully received.