Re: $$Excel-Macros$$ Formula Required

2013-10-22 Thread De Premor
another way :) =UPPER(LEFT(A2,1)&LEFT(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",99)),99)))&TEXT(B2,"DDMM")&LEFT(C2,1)&RIGHT(C2,1)) On 22-10-2013 17:51, Anoop K Sharma wrote: PFA updated with little change as described above. On Tue, Oct 22, 2013 at 4:18 PM, Anoop K Sharma mailto:aks.sharm.

$$Excel-Macros$$ Re: Continuation of VBA for Excel to Word

2013-10-22 Thread Justin Pulley
Still getting error 462 every other time I run the macro. not sure how to beat this error. On Monday, October 21, 2013 8:21:02 AM UTC-7, Justin Pulley wrote: > > I don't know how to mark something uncompleted. > > The code works every other time. > > > > Sub CreateReportPDF() > Dim wdapp As W

$$Excel-Macros$$ Extract data in worksheet in xml format to another sheet

2013-10-22 Thread Jorge Marques
Hi guys I have an excel that has 44800 lines(I have a xml that I insert in the excel), it is inventory information, my doubt is How can I copy the lines that start with https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ Formula Required

2013-10-22 Thread Anoop K Sharma
PFA updated with little change as described above. On Tue, Oct 22, 2013 at 4:18 PM, Anoop K Sharma wrote: > As Requested, PFB the solved one. > > Regards, > Anoop > Sr. Developer > > > On Tue, Oct 22, 2013 at 3:36 PM, xlstime wrote: > >> please share the example >> >> .

Re: $$Excel-Macros$$ Formula Required

2013-10-22 Thread Anoop K Sharma
As Requested, PFB the solved one. Regards, Anoop Sr. Developer On Tue, Oct 22, 2013 at 3:36 PM, xlstime wrote: > please share the example > > . > > Enjoy > Team XLS > > > > On Tue, Oct 22, 2013 at 10:28 AM, Prabhakar Thakur < > prabhakarthak...@gmail.com> wrote: > >> D

$$Excel-Macros$$ Fwd: Most people think there’s only one way to use Excel’s VLOOKUP

2013-10-22 Thread Kuldeep Singh
-- Forwarded message -- From: My Online Training Hub Date: Tue, Oct 22, 2013 at 9:16 AM Subject: Most people think there’s only one way to use Excel’s VLOOKUP To: Kuldeep Singh ** [image: logo] Home |

Re: $$Excel-Macros$$ Formula Required

2013-10-22 Thread Prabhakar Thakur
Hi, Example like this Name Dob Town Ex Ram Kumar 15-Oct Kota RK15102013KA Ram kumar Mishra 18-Sep Patna RM18091988PA Ram rajat kumar Mishra 20-Jul Delhi RM20072013DI Thanks, Prabhakar Thakur New Delhi +919953736776 On Tue, Oct 22, 2013 at 3:36 PM, xlstime wrote: > please share

Re: $$Excel-Macros$$ Formula Required

2013-10-22 Thread xlstime
please share the example . Enjoy Team XLS On Tue, Oct 22, 2013 at 10:28 AM, Prabhakar Thakur < prabhakarthak...@gmail.com> wrote: > Dear Team, > > > > > > I need a formula for create unique ID. > > > > Unique ID=first character of first Name + last name first character

$$Excel-Macros$$ Re: QC results update tool

2013-10-22 Thread Tushar Goswami
Hi Nevin, I am also looking for similar solutions, please let me know if you have figured out the solution of uploading test result from excel to Quality Centre. Thanks, Tushar On Wednesday, November 7, 2012 10:28:45 AM UTC+11, Nevin wrote: > > Hi Friends, > > Did you guys find time to look