Bring a code from a cell to a column
Dear all
I am working in Office 2003 edition. I have export from an ERP a sheet where ther are some codes with some prices and the information are split it to paragraphs. For example in cell D150 i have the code of a group of products and followed from line D156-D165 with subcodes of sub-parts of the specific code product. The case. I want to bring in cells A156-A165 the code of D150. This will help me to have in column A the main Code and in column B the sub codes. Imagine an excel sheet with 25.000 lines, so i am looking for an easy way of copying and paste fomrula. Also there is a possibility when a line is empty not to bring anything? Because as i said the information is spli it in paragraphs and i have quite a lot of empty lines. There is a smaple file in the following link: http://rapidshare.com/files/7903304/SAMPLE.xls.html Thanks in advance Manos |
Bring a code from a cell to a column
Anyway you can put sample material in the columns? I'm looking at it but not
really understanding what type of data will be there. -- -John Please rate when your question is answered to help us and others know what is helpful. "Manos" wrote: Dear all I am working in Office 2003 edition. I have export from an ERP a sheet where ther are some codes with some prices and the information are split it to paragraphs. For example in cell D150 i have the code of a group of products and followed from line D156-D165 with subcodes of sub-parts of the specific code product. The case. I want to bring in cells A156-A165 the code of D150. This will help me to have in column A the main Code and in column B the sub codes. Imagine an excel sheet with 25.000 lines, so i am looking for an easy way of copying and paste fomrula. Also there is a possibility when a line is empty not to bring anything? Because as i said the information is spli it in paragraphs and i have quite a lot of empty lines. There is a smaple file in the following link: http://rapidshare.com/files/7903304/SAMPLE.xls.html Thanks in advance Manos |
Bring a code from a cell to a column
An example
http://rapidshare.com/files/7918925/SAMPLE2.xls.html "John Bundy" wrote: Anyway you can put sample material in the columns? I'm looking at it but not really understanding what type of data will be there. -- -John Please rate when your question is answered to help us and others know what is helpful. "Manos" wrote: Dear all I am working in Office 2003 edition. I have export from an ERP a sheet where ther are some codes with some prices and the information are split it to paragraphs. For example in cell D150 i have the code of a group of products and followed from line D156-D165 with subcodes of sub-parts of the specific code product. The case. I want to bring in cells A156-A165 the code of D150. This will help me to have in column A the main Code and in column B the sub codes. Imagine an excel sheet with 25.000 lines, so i am looking for an easy way of copying and paste fomrula. Also there is a possibility when a line is empty not to bring anything? Because as i said the information is spli it in paragraphs and i have quite a lot of empty lines. There is a smaple file in the following link: http://rapidshare.com/files/7903304/SAMPLE.xls.html Thanks in advance Manos |
All times are GMT +1. The time now is 09:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com