Search results

I have a list in column A which is indented. I want each indent level to be in different column, how do I do that? Related Question: I want to find out indent level of each cell, is there an easy way. There is an VBA code, but is there another way?

Here it is. Also shows the required report.

I have some data that has the following columns: Date, vendor name, invoice number, invoice date, amount and sales region. I want to make a pivot that will show me the location wise details of sales. In addition to that I want the pivot to give the details of sales in the following buckets...

Thanx a lot that really helped.

Is there any way that we can use the Concatenate formula to provide formulas to excel to execute. For Eg. if we use the formula =Concatenate("=",2,"+",2) Excel gives output as =2+2 and not 4. is there a way we can do this. I have read about the Morefunc Addon but it does not work with Excel...

I have been trying to use XML in Excel. My XML file contains around 500 fields. I have 2 queries. 1. When I drag the entire XML file The data is arranged in a Horizontal table format. Is there any way to put that in Vertical tables. 2. Is there a way I can use that 500 field in the old Excel...

I have a file that has the following columns. Sr. LastName FirstName MiddleName PAN I need to find errors in the PAN column. The rules are as under: 1. Form is AAAPA9999A i.e. First 4 Alphabets then 4 Numbers then 1 Alphabet. 2. Fourth Alphabet has to be "P". 3. Fifth Alphabet has to be...