I am attempting to parse a string data value that is read from a Microsoft Access database into a single Microsoft Excel 2000 cell. The format of the data string is as follows:
aDaXa+a
where “a” is a numerical value of any number of digits and “D”, “X” and “+” are the delimeters of the values.
I have read an excellent discussion about parsing using the Text to Columns command, but I have run into a problem. I need to deposit the 2 results of my parse (i.e., the value, and the remainder of the string) into 2 cells that are A) not in adjacent cells and/or columns, and B) not on the same page as the original data. Can someone help me get this to work? I have tried playing around with the Text to Columns command for about 3 days so far and I still cannot get anywhere.
Thanks for any help you can give me.