Ride The Lightning
Board Regular
- Joined
- Jul 14, 2005
- Messages
- 238
Hi
I have data in Column A: 1And, 3And, 12And etc
I am trying to retrieve the numbers in The cells in column A and move them to column B, so Columns A and B should read: (A) And, And, And (B) 1, 3, 12.
I have tried the "Text to Columns" wizard but I can only move certain parts of the text string and not just the numbers.
Is there a formula to achive this?
Regards
RTL
I have data in Column A: 1And, 3And, 12And etc
I am trying to retrieve the numbers in The cells in column A and move them to column B, so Columns A and B should read: (A) And, And, And (B) 1, 3, 12.
I have tried the "Text to Columns" wizard but I can only move certain parts of the text string and not just the numbers.
Is there a formula to achive this?
Regards
RTL