peteroldfield1971
New Member
- Joined
- Apr 27, 2005
- Messages
- 48
Hi,
Can any one help me do the following?
In column A I have a string of text eg:
1. in my life - the beatles
In cell B1 i want "1", in cell C1 "2in my life" and in D1 "the beatles"
I would like to run this with a button if possible to repeat the macro through rows 1 to 180.
Any one help?
Many thanks.
Can any one help me do the following?
In column A I have a string of text eg:
1. in my life - the beatles
In cell B1 i want "1", in cell C1 "2in my life" and in D1 "the beatles"
I would like to run this with a button if possible to repeat the macro through rows 1 to 180.
Any one help?
Many thanks.