Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.



  • Please log in to reply
4 replies to this topic

#1 evergreen1


  • Members
  • 52 posts
  • Local time:10:19 PM

Posted 27 April 2013 - 09:41 PM

Mod edit: Moved to more appropriate forum from XP... Business Applications    ~~ boopme          




I  have taken this data from a text file into word. this is how it looks. now i want to justify it. it is not being done when i click on the justify button. is there any way to do this? is there a way to get this data into excel columns.this is a chess game notation. so i would like to get it in columns movewise.thanks





1.d4 Nf6 2.c4 d6 3.Nf3 Nbd7 4.Nc3 e5 5.e4 Be7 6.Be2 O-O 7.O-O

c6 8.Qc2 Re8 9.Rd1 Bf8 10.Rb1 a5 11.d5 Nc5 12.Be3 Qc7 13.h3

Bd7 14.Rbc1 g6 15.Nd2 Rab8 16.Nb3 Nxb3 17.Qxb3 c5 18.Kh2 Kh8

19.Qc2 Ng8 20.Bg4 Nh6 21.Bxd7 Qxd7 22.Qd2 Ng8 23.g4 f5 24.f3

Be7 25.Rg1 Rf8 26.Rcf1 Rf7 27.gxf5 gxf5 28.Rg2 f4 29.Bf2 Rf6

30.Ne2 Qxh3+ 31.Kxh3 Rh6+ 32.Kg4 Nf6+ 33.Kf5 Nd7 34.Rg5 Rf8+

35.Kg4 Nf6+ 36.Kf5 Ng8+ 37.Kg4 Nf6+ 38.Kf5 Nxd5+ 39.Kg4 Nf6+

Edited by boopme, 27 April 2013 - 11:41 PM.

BC AdBot (Login to Remove)


#2 Chris Cosgrove

Chris Cosgrove

  • Moderator
  • 7,107 posts
  • Gender:Male
  • Location:Scotland
  • Local time:03:19 AM

Posted 28 April 2013 - 04:25 PM



I don't think there is an easy way !  I've just tried copying / pasting your text into both Word 2003 and Excel 2003. In Word, I can get each line to fit to one line by resizing the font, but it won't justify. In Excel, each line of your text fills one cell.


I can think of one way that will get it into columns in Excel, and one that might !  And they are both fairly tedious. First one, copy the text for each move and paste it, one move at a time, into different cells in Excel - this will work. The one that might work is to separate each move by a comma and then save it as a .CSV ( Comma Separated Values ) file, then open that in Excel.


Your choice.


Chris Cosgrove

#3 Budapest


    Bleepin' Cynic

  • Moderator
  • 23,579 posts
  • Gender:Male
  • Local time:01:19 PM

Posted 28 April 2013 - 05:00 PM

You should be able to get the data into different cells by first pasting it into the EXCEL spreadsheet. Then highlight all the data and select Data > Text to Columns > Delimited > and check "Space".

The power of accurate observation is commonly called cynicism by those who haven't got it.

—George Bernard Shaw

#4 AngryRaisin


  • Members
  • 235 posts
  • Gender:Male
  • Location:Orange County, CA, US
  • Local time:07:19 PM

Posted 28 April 2013 - 07:01 PM

For justify
'shift + enter' at the end of every line instead of regular 'enter'

like this


as for 'get it into an excel file'... sure copy paste info into an excel file but if you have hundreds of entries that you would like to import into excel that would be importing them into excel but that question is harder to answer and if my first solution fits your needs then I'd like to leave it at that.

Edited by AngryRaisin, 28 April 2013 - 07:16 PM.

#5 Bankbuddy


  • Members
  • 1 posts
  • Local time:08:19 PM

Posted 15 May 2013 - 12:54 PM

Another option in MS Word (I have 2003, yuk): Columns.  Highlight the text, then >Format, >Columns, and select the # of columns and adjust column width to taste. I tried it, and it looks good BUT requires much adjusting the spacing of the text and other spacing format options. Good luck! 

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users