RE: $$Excel-Macros$$ how do you identify the first space within a series of words within a a text

Hi Edgar, You are searching for "" which is a zero-length string. Perhaps it should be " " which is a space. Regards - Dave. > Date: Wed, 21 Jul 2010 14:48:01 -0700 > Subject: $$Excel-Macros$$ how do you identify the first space within a series > of words within a a text > From: ejax...@

Re: $$Excel-Macros$$ how do you identify the first space within a series of words within a a text

Hi Edgar, Function you are applying is correct. So please attached your file so that problem can be solved. Thanks & Regards Sandeep On Thu, Jul 22, 2010 at 3:18 AM, Edgar wrote: > I'm trying to clean up some data. I've used SEARCH and FIND to try to > identify the first space within a cell, bu

$$Excel-Macros$$ Re: excel help

Hi Preeti Pls let us know what you want to do, or if possible please attach a sample sheet. Regards Rajender Soni ! 750 322 55 50 On Jul 21, 8:31 pm, preeti vora wrote: > Hi team, > > when we do vlookup is that possible without col_index_num and range_lookup > for use vlookup..or can we use any

$$Excel-Macros$$ Re: $excel-macros$ help

Hi Preeti Please find attached the solution as required, do let me know if something else is required. Regards, Rajender Soni | +91 750 322 55 50 -- -- Some important links for excel users: 1. Follow us on TWITTER

$$Excel-Macros$$ how do you identify the first space within a series of words within a a text

I'm trying to clean up some data. I've used SEARCH and FIND to try to identify the first space within a cell, but the answer comes back incorrect. I've used SEARCH("", Cell Reference) It's giving me the first cell. For example, the answer to this would be 1. If I used SEARCH("", Cell reference,

$$Excel-Macros$$ Re: $excel-macros$ help - merge sheets into one sheet

Hi preeti, This code covers your task, you can run it and enjoy. It was interesting problem to solve. Please tell us does it work for you. Sub automate() Dim i, j, k, n, myfile, mySheet Call ListWorkSheetNames myfile = ActiveWorkbook.FullName Sheets("main sheet").Select Cells.Select

$$Excel-Macros$$ Re: $excel-macros$ help

Hi preeti, This code covers your task, you can run it and enjoy. It was interesting problem to solve. Please tell us does it work for you. Sub automate() Dim i, j, k, n, myfile, mySheet Call ListWorkSheetNames myfile = ActiveWorkbook.FullName Sheets("main sheet").Select Cells.Select

$$Excel-Macros$$ $excel-macros$ help

Hi team i have one excel file there is 10 to 15 sheet different but i want to marge in one sheet is that possible to do??? -- Regards, Preeti Vora. -- -- Some important links for excel users: 1. Follow us on TWIT

$$Excel-Macros$$ Re: Reverse of rounding

On 20 Jul., larry wrote: > > > I have a macro where I copy data into an array from one sheet and then > > > post it in another sheet and there is something odd. .8 becomes , > > > 79, .15 becomes .1501. The other way around this would be > > > rounding. It only changes the values in the fir

$$Excel-Macros$$ excel help

Hi team, when we do vlookup is that possible without col_index_num and range_lookup for use vlookup..or can we use any other function instead of vlookup... -- Regards, Preeti Vora. -- -- Some important links for e

$$Excel-Macros$$ Extract Nth word from string

I hope this would be helpful for sum1..See attached file. Warm Regards, Harmeet Singh IT Analyst McKinsey & Company http://www.facebook.com/Harmeeet -- -- Some important links for excel users: 1. Follow us

$$Excel-Macros$$ Re: Reverse of rounding

Since the data was hard entered, typed directly, there shouldn't be any extra digits hanging around. There are differences in the cell formats for the two sheets and then throw in what ever format I am using for the array, of course I should be expecting something odd. On Jul 20, 10:12 am, Stuart

RE: $$Excel-Macros$$ Need SUMIF with 3 criteria

Hi, Sample workbook please. Regards - Dave. Date: Mon, 19 Jul 2010 16:43:59 -0700 From: n8dine4ma...@yahoo.com Subject: $$Excel-Macros$$ Need SUMIF with 3 criteria To: excel-macros@googlegroups.com I need to sum a column if three other columns in one sheet match the three in another.

$$Excel-Macros$$ Re: [Fwd: Help for format converson required]

Hi Pradeep, I know that LIC works on Linux environment, no problems.. I have revamped the solution as per your requirements. Please see the attached file and get back in case of any queries. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail

Re: $$Excel-Macros$$

Hi , I can help but I need your full requirement. Regards Vimal On Wed, Jul 21, 2010 at 11:36 AM, Kumar Punnam wrote: > Dear Friends, > > > I ravi working for construction company , having problem gathering of data > in day to day bases, i had up loaded my excel sheet stating my requirement, >

Re: $$Excel-Macros$$

Hi Ravi, Your requirement is not clear from excel sheet. Please explain. Ravi - Original Message - From: Kumar Punnam To: excel-macros@googlegroups.com Sent: Wednesday, July 21, 2010 11:36 AM Subject: $$Excel-Macros$$ Dear Friends, I ravi working for