Re: $$Excel-Macros$$ How to order data in rows into distinct column sets

2013-01-31 Thread Alpesh Shah
hed Sheet for Your REf. is i sOK? > > > Warm Regards, > Gawli Anil > > On Thu, Jan 31, 2013 at 3:12 AM, Alpesh Shah wrote: > >> Dear Excel Masters, >> >> I have raw data that is in the following form: >> >> 1 name abc >> 2 address 234 joh

$$Excel-Macros$$ How to order data in rows into distinct column sets

2013-01-30 Thread Alpesh Shah
Dear Excel Masters, I have raw data that is in the following form: 1 name abc 2 address 234 john lane 3 company inc, co 4 website http://website.com 5 description company abc is abc What I would like to do is have this information look like this, where the data is taken from rows and transpos

$$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells

2012-08-04 Thread Alpesh Shah
Dear Excel Experts, I am working with a string as follows: " | ABC:2013| ABCD| EFGH|2IJK | 3243| 9s9s| afjkdf|" There are a total of 8 pipes | . My issue is that I am trying to Split this based on the pipes, and output the words in between into cells. I have been trying to solve this for a lon

$$Excel-Macros$$ Excel 2010: Review each cell in a spreadsheet, Parse it, Rejoin it in Spreadsheet

2012-07-20 Thread Alpesh Shah
Dear Excel Experts, I have attached a spreadsheet with dummy data. The first tab shows the dummy information and the second tab shows what I would like it to look like. As I have over 100 of rows of data to do this for, I am looking to develop some vba code to help accelerate the work. Each row on

Re: $$Excel-Macros$$ PowerPoint to excel

2012-07-17 Thread Alpesh Shah
Ashish, You have done something I did not think was possible. I'm very impressed and I thank you for your time and effort. Best regards, Alpesh On Tue, Jul 17, 2012 at 10:42 AM, ashish koul wrote: > in tools reference add Microsoft powerpoint > > > Sub import_textbox_text_ppt_excel() > ' refre