Question Locked

Parsing Strings-The secret is: Location, Location, Location

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by thumbsup2

If you need it to end up on another sheet and not in adjacent cells, you'll have to find another way to do it. Text to Columns will not do it all by itself.

However, you can use T to C and parse the information, then MOVE it to where you want it.

This discussion is closed to new replies.