Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 04-18-2009, 11:01 AM
Boubas1 Boubas1 is offline
Registered User
 
Join Date: 18 Apr 2009
Location: France
MS Office Version:Excel 2003
Posts: 4
Boubas1 is becoming part of the community
Cellules décallées si copie tableau word dans excel

Please Register to Remove these Ads

Bonjour,

J'aimerais pouvoir exploiter 1 tableau word sur excel en collant celui ci dans excel. Mais lorsque je copie le tableau word dans excel, certaines cellules de la colonne pièce se trouve décallées par rapport au tableau word d'origine. Par exemple, vous pouvez constater que le n° de pièce 174 ne se trouve plus en face le n° d'Art 605 et le n° de pièce 180 ne se trouve plus en face le n° d'Art 637 mais 638 sous excel.
Pouvez vous me dire svp comment régler ce problème car j'aimerais ensuite pouvoir faire des sous totaux en fonction des numéros de pièces. Merci.

Ci joint les tableaux word et excel en question
Attached Files
File Type: zip Testcopiercollerexcelword.zip (11.6 KB, 6 views)
File Type: xls Testcopiercollerexcelword.xls (30.5 KB, 5 views)
Reply With Quote
  #2  
Old 04-18-2009, 06:33 PM
oldchippy's Avatar
oldchippy oldchippy is offline
"Eagle Eyed" Forum Moderator
 
Join Date: 14 Feb 2005
Location: Worcester, UK
MS Office Version:Excel 2007 (Work) and 2007 (Home)
Posts: 6,933
oldchippy is attaining expert status oldchippy is attaining expert status
Re: Cellules décallées si copie tableau word dans excel

See an English version here or

Voir une version en anglais ici

http://www.excelforum.com/excel-gene...cel-table.html
__________________
oldchippy
-------------


If you are happy with the help you have received, please add to our reputation by clicking the blue scales icon in the blue bar of the post.

Click here >>> Top Excel links for beginners to Experts

Forum Rules >>>Please don't forget to read these

Last edited by oldchippy; 04-18-2009 at 06:36 PM. Reason: Translation added
Reply With Quote


Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Forum Jump