I am trying to convert all the data in a particular column to "<word> <letter> <numbers>". Some are "<word> <letter>", some are "<letter> <numbers>". Is there a formual that will auto add in these fields to every cell? I have attached a file to demonstrate further what I mean. Thanks in advance! Book1.xls
Bookmarks