Results 1 to 2 of 2

Thread: EXCEL export to tekst or sheet

  1. #1
    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!!!

  2. #2
    Join Date
    May 2008
    Posts
    4,345

    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.

Similar Threads

  1. Replies: 2
    Last Post: 23-02-2012, 02:59 PM
  2. What is the use of time sheet in excel
    By Chini mao in forum MS Office Support
    Replies: 1
    Last Post: 08-01-2012, 04:35 PM
  3. Export Excel 2003 sheet in csv Format
    By BADRU in forum Windows Software
    Replies: 3
    Last Post: 06-04-2009, 10:23 PM
  4. How to export column from one sheet to another sheet ?
    By Metechman in forum Windows Software
    Replies: 3
    Last Post: 26-02-2009, 07:11 PM
  5. How to Export a table from a PDF File into an Excel Sheet
    By Computer_Freak in forum Tips & Tweaks
    Replies: 1
    Last Post: 05-02-2009, 10:51 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,643,051,492.60576 seconds with 17 queries