jlbecker67
New Member
- Joined
- Mar 26, 2002
- Messages
- 8
How can I move certain data from one column to another? Example:
John Doe.....123.....W...........Main.....St
Jane Doe.....987.....Nowhere.....St
As you can see the street name is shifted left because of the absence of the direction designation. How can I do move all the "St"'s in the wrong column to the right one and then move the street name to the right column? Can I have a formula that finds the two letter designations and moves them to the column to the right? And then have one that finds all data with more than two letters (for the street name) and move it to the column to the right?
Thanks for your help. Sorry I am so ignorant.
Jerry
John Doe.....123.....W...........Main.....St
Jane Doe.....987.....Nowhere.....St
As you can see the street name is shifted left because of the absence of the direction designation. How can I do move all the "St"'s in the wrong column to the right one and then move the street name to the right column? Can I have a formula that finds the two letter designations and moves them to the column to the right? And then have one that finds all data with more than two letters (for the street name) and move it to the column to the right?
Thanks for your help. Sorry I am so ignorant.
Jerry