DaciaClub Logo

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topicStart Poll

Outline · [ Standard ] · Linear+

> Cum trec o lista din word in excel, da' repede, fara sa o transcriu ad labam

Marty
post 1 Feb 2010, 10:23
Post #1


Membru cu privire de ansamblu


Group: Members
Posts: 5.840
Joined: 14 April 03
From: Corbu




Asadar, am o lista de vreo 90 de linii, care are 5 coloane. Bine, le are doar vizual, da' nu-s definite ca atare, tot documentul fiind text.
Folosind Office 2003 (cu licenta), se poate face trecerea din document text in excel, fara a trebui sa le scriu de mina?


--------------------
Gillette De unica folosinta 2011 - B 999 NAM
Mindru absolvent de grup scolar.
User is offlineGalerie FotoPM
Go to the top of the page
+
driverx
post 1 Feb 2010, 10:27
Post #2


--- Membru cu ralanti ---


Group: Members
Posts: 7.656
Joined: 21 November 03




Try this: http://office.microsoft.com/en-us/help/HP051994191033.aspx

Ar mai fi o solutie. Sa salvezi docu Word ca si text, adica partea cu tabela, dupa care din excel sa faci import si sa ii specifici separatorii... Da' asta e mai tricky daca n-ai mai facut...

This post has been edited by driverx: 1 Feb 2010, 10:29


--------------------
Mitsubishi Lancer 2008
Univega Alpina HT-LTD Disc Deore 2011
User is offlineGalerie FotoPM
Go to the top of the page
+
LuluMOB
post 1 Feb 2010, 10:28
Post #3


Membru cu pedale.


Group: Members
Posts: 1.136
Joined: 28 October 05
From: Iași




Pai la el nu e tabel... nu?


--------------------
Dacia Logan ABS+ AC 1.4MPI 06/2007
User is offlineGalerie FotoPM
Go to the top of the page
+
driverx
post 1 Feb 2010, 10:30
Post #4


--- Membru cu ralanti ---


Group: Members
Posts: 7.656
Joined: 21 November 03




Atunci ramane varianta 2 smile.gif


--------------------
Mitsubishi Lancer 2008
Univega Alpina HT-LTD Disc Deore 2011
User is offlineGalerie FotoPM
Go to the top of the page
+
Marty
post 1 Feb 2010, 10:30
Post #5


Membru cu privire de ansamblu


Group: Members
Posts: 5.840
Joined: 14 April 03
From: Corbu




QUOTE(driverx @ 1 Feb 2010, 10:27)
Ar mai fi o solutie. Sa salvezi docu Word ca si text, adica partea cu tabela, [...]
*

Ce-ai, ba, te-ai lovit la ceas? Ce tabela? N-auzi ca coloanele sunt definite prin citeva tab-uri bine tintite?


1 Feb 2010, 10:31:
QUOTE(driverx @ 1 Feb 2010, 10:30)
Atunci ramane varianta 2 smile.gif
*

Dama cu camelii? unsure.gif


This post has been edited by Marty: 1 Feb 2010, 10:31


--------------------
Gillette De unica folosinta 2011 - B 999 NAM
Mindru absolvent de grup scolar.
User is offlineGalerie FotoPM
Go to the top of the page
+
Stefan
post 1 Feb 2010, 10:35
Post #6


Quite opinionated


Group: Members
Posts: 1.449
Joined: 18 January 08
From: Cluj-Napoca




Ar fi o idee, nu stiu daca te ajuta:
Poti da copy paste la tot din word in excel - totul va intra intr-o singura coloana, dar exista posibilitatea sa le separi automat, folosind functia "text to column". Coloanele vor fi inserate dupa delimitatorii pe care-i alegi - tab, virgula, space, etc. Sper sa te ajute.

http://office.microsoft.com/en-us/excel/HA011498511033.aspx

LE: ah, vad ca a raspuns si driverx inainte. biggrin.gif.

This post has been edited by Stefan: 1 Feb 2010, 10:36


--------------------
Volkswagen Golf 7 Variant 1,4 TSI 2013
User is offlineGalerie FotoPM
Go to the top of the page
+
b64chr
post 1 Feb 2010, 10:36
Post #7


Moderator incepator


Group: Moderatori
Posts: 1.004
Joined: 17 December 04
From: Buzias, Timis




Copiezi tot textul, il trantesti cu paste in excel.
Apoi mergi la Data -> Text to columns... si de acolo te descurci.

P.S. Na ca mi-a luat-o Stefan inainte.

This post has been edited by b64chr: 1 Feb 2010, 10:37


--------------------
Dacia Solenza 2003 / Skoda Octavia 2009
User is offlineGalerie FotoPM
Go to the top of the page
+
Marty
post 1 Feb 2010, 10:42
Post #8


Membru cu privire de ansamblu


Group: Members
Posts: 5.840
Joined: 14 April 03
From: Corbu




Stefan, respekt.gif worship.gif

driverx, multumesc, m4n3!!! 04.gif Cu paste special incercasem deja.

L.E.: b64chr, merci!

This post has been edited by Marty: 1 Feb 2010, 10:43


--------------------
Gillette De unica folosinta 2011 - B 999 NAM
Mindru absolvent de grup scolar.
User is offlineGalerie FotoPM
Go to the top of the page
+
Reply to this topicTopic OptionsStart new topic


1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
 

ETask
Lo-Fi Version  Harta site  Parteneri  Jocuri online  Curs Valutar  HRH Haine din lana merinos Time is now: 9th June 2024 - 02:38
Forum Renault