Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 29-06-2009
Member
 
Join Date: Jun 2009
Posts: 2
EXCEL export to tekst or sheet

Hello,

I've got a question, that shouldn't be too difficult for the export-sheet operator (I hope!) :-)

I have 5 columns filled with different data:

1; 001701; D090618; FL00001; 200010118708;

1. scannumber
2. invent. code
3. date
4. location (about 1000 different locations)
5. barcode (about 10.000 barcodes)

I want the each row of data seperated in the columns to merge to:

I0001|001701|***
D090618|FL00001
200010118708|001
I0001|001701|***
D090618|FL00005
200010118386|001
etcetc..

I prefer to export it to a tekstfile. But if someone can get it into a format on a different sheet or row, thats fine too!

Thanks in advance!!!
Reply With Quote
  #2  
Old 29-06-2009
Member
 
Join Date: May 2008
Posts: 4,339
Re: EXCEL export to tekst or sheet

Here is a very simple formula by which you can merge the two different columns in a Microsoft Excel Spreadsheet. The only requirement here is that the result will be displayed in a different column. You can select as many columns you want. Here what is you have to do. Click in a empty cell and type =(A1&" "$B1). A1 is the first column and B1 is the second column. Press enter. Always close the bracket. In the same way keep on adding as much you want. Eg =(A1&" "&B1&" "&C1&" "&D1&" "&E1). Then the third columns has only formula not text. If you delete any cell reference like in A1 the result will disappear. There is one more option in excel by which you can convert the formula into text. Right click on the cell which has formula a select copy. Then same way right click and click on paste special. In the window select Value and give OK. All the formula will turn to text. Best of luck.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "EXCEL export to tekst or sheet"
Thread Thread Starter Forum Replies Last Post
How to use Mail Merge from one Excel Sheet to another Excel Sheet Abélard MS Office Support 2 23-02-2012 02:59 PM
What is the use of time sheet in excel Chini mao MS Office Support 1 08-01-2012 04:35 PM
Export Excel 2003 sheet in csv Format BADRU Windows Software 3 06-04-2009 10:23 PM
How to export column from one sheet to another sheet ? Metechman Windows Software 3 26-02-2009 07:11 PM
How to Export a table from a PDF File into an Excel Sheet Computer_Freak Tips & Tweaks 1 05-02-2009 10:51 AM


All times are GMT +5.5. The time now is 01:13 PM.