Thread: separate text and numbers
View Single Post
  #3  
Old 08-22-2007, 09:05 PM
Steel Monkey Steel Monkey is offline
Valued Forum Contributor
  
Join Date: 23 Nov 2005
Location: Perth, Australia
Posts: 219
Steel Monkey is an unknown quantity at this point
separate text and numbers
I would use text to columns, there is an option to treat consecutive delimiters as one. If you select this it should not matter if there is more then one space.....
Reply With Quote