Seperating sections of a string of values
Posted by Simon Scott on September 28, 2000 9:32 AM
OK here is the scenario. I have a string of values in column A, lets say 10 values: AB12345XYZ
I need a function that can write in Column B and it will take the first two characters, AB, and put them into Column B and then I can use the same funtion in Column C to take the next 5 characters and finally use the same function in Column D and take the last 3 Characters.
Any ideas what the function is?