morocco31477 Posted August 26, 2007 Share Posted August 26, 2007 How would I divide one cell into two cells? For example, in column A, I have:abcdefg blah blah blah blahxoxoxo blah blah dee dee dahect ectHow would I divide this into two different columns? I'm using Microsoft Office '07. Link to comment Share on other sites More sharing options...
IcemanND Posted August 26, 2007 Share Posted August 26, 2007 how is it you are determining where the split is. Link to comment Share on other sites More sharing options...
morocco31477 Posted August 26, 2007 Author Share Posted August 26, 2007 how is it you are determining where the split is.Oh, there are like four spaces after the first set of letters, but I guess this forum auto-corrects extra spaces. So, let's ignore the periods:abcdefg.....blah blah blah blahxoxoxo.....blah blah dee dee dahect ectLike that, where the five periods are. Link to comment Share on other sites More sharing options...
morocco31477 Posted August 26, 2007 Author Share Posted August 26, 2007 Nevermind, I figured it out. Thank you though. Link to comment Share on other sites More sharing options...
IcemanND Posted August 26, 2007 Share Posted August 26, 2007 select the desired cells/column.On the Data tabin the Data tools groupclick text to columnscomplete the wizard as desired. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now