EXCEL export to tekst or sheet
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;
2. invent. code
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:
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!!!
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.
|Tags: excel 2003|
|Thread Tools||Search this Thread|
|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|