Re: [bulk] $$Excel-Macros$$ Extract Text

p://karanxel.blogspot.com/> <http://karanxel.wordpress.com/> On Tue, Nov 1, 2011 at 3:33 PM, Siraj Momin (BTG) wrote: > PFA > > ** ** > > Best Regards > > ** ** > > * * > > Momin Siraj Ahmad > > ** ** > > *From:* excel-macr

$$Excel-Macros$$ Extract Text

Dear All, I've around 8k cell which has data showing below, I need your help to extract specific text from the string. I need to extract text after first comma ( *,* ) & before left paranthesis as showing below. Kindly help. Govt College of Engineering, Wayanand, P O Nallurnad, Mananthavady (19

Re: $$Excel-Macros$$ FW: Village

Amazing..!! Kaяan On T

Re: $$Excel-Macros$$ Extract (Text & Numbers)

Thanks a lot neil but there is a query (Pincode) which has not solved yet. I've to extract Pin Code from the text as I'v written on mail & worksheet. Kindly help me in this. Thanks Kaяan

Re: $$Excel-Macros$$ Extract (Text & Numbers)

p://karanxel.blogspot.com/> <http://karanxel.wordpress.com/> On Thu, Oct 20, 2011 at 9:57 AM, karan 1237 wrote: > Dear All, > > Hope you all are doing well..! > I need your assistance to sort out my problem. I need to extract Pincode, > Principal Name, Establishment. I'v

$$Excel-Macros$$ Extract (Text & Numbers)

Dear All, Hope you all are doing well..! I need your assistance to sort out my problem. I need to extract Pincode, Principal Name, Establishment. I'v attached the sheet. Kindly help. Thanks Kaяan

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hey Anil, Convert your image files in excel through online or download a software from the website below : http://www.onlineocr.net/ http://www.cometdocs.com/ http://www.coolutils.com/Online-Excel-Converter.php http://document.online-convert.com/convert-to-pdf http://www.pdfconverter.com/

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hey Anil, Please find enclosed. Kaяan

Re: $$Excel-Macros$$ can we change hard copy in excel

Yes you can convert your image files in excel through online or download a software from the website below : http://www.onlineocr.net/ http://www.cometdocs.com/ http://www.coolutils.com/Online-Excel-Converter.php http://document.online-convert.com/convert-to-pdf http://www.pdfconverter.com/ http:/

Re: $$Excel-Macros$$ Shortcut key for Border

Hey Ankit, Please see below image : For all border press Alt+H+B+A For outline border Ctrl+Shift+& & for all border commands press Alt+H+B+ then press character which is showing in the image below: [image: Picture1.jpg] Kaяan

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

Hey Waheeb, Pls find enclosed. Kaяan

Re: $$Excel-Macros$$ Working out of Statistics on Exam Results URGENT solution needed!

Hey Shane, If your workbook size is more than 10 MB, you can compressed its size through this : Save as or press F12 >From "Save as type" drop down & save your file in Excel Binary Format. Just try this. Kaяan

$$Excel-Macros$$ Extract 6 & 7 Digit Number

Dear All, Hope you all are doing well ! I need your assistance to sort out my problem. I need to extract 6 & 7 Digit number from the string. Example : I. C, Rajendra Palace, New Delhi 110053 II. C, 301 Rajendra Palace, 110053 New Delhi III. C, Rajendra Palace, 110 053 New Delhi *Result : * I.

$$Excel-Macros$$ Extract (%) Numbers from the text

Hello All, Hope you all are doing well. I'm here as usual, need your assistance. I'v text data which have percentage numbers (50% or 60%), I need to extract minimum percentage number. Kindly help me to sort out this problem. Text is : minimum qualification pcm with 50% or MCA 60% Result should be

Re: $$Excel-Macros$$ Transpose Data from cell to columns

t to column > . > > > On Tue, Sep 13, 2011 at 5:02 PM, karan 1237 wrote: > >> Dear Noorain thanks for replying, but still my query has not solved. I >> want to transpose data from cell to columns, I don't want to do Text to >> columns. Plea

Re: $$Excel-Macros$$ Transpose Data from cell to columns

c, i, 1)) < 91 Then > Range("a" & x).Offset(0, d).Value = Left(abc, i - 1) > xyz = Right(abc, Len(abc) - i + 1) > abc = xyz > i = 1 > d = d + 1 > End If > Next i > If Len(Range("a" & x).Value) = Len(abc) Then > Range("a" & x).

$$Excel-Macros$$ Transpose Data from cell to columns

Dear All, I'v to transpose data from a cell to columns. Please solve my query. Thnx in advance Kaяan

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

I knewcongrats Rajan..!!! You are great...!!! ~~~ Karan www.karanxel.blogspot.com ** On Thu, Aug 4, 2011 at 9:50 AM, Dilip Pandey wrote: > Congratulations Rajan...!! > > Regards, > DILIPandey > > On 8/3/11, Ayush Jain wrote: > >> > >> Hello Everyone, > >>> > >>> Rajan Verma has been

Re: $$Excel-Macros$$ Difference between Array formula and Normal Formula...

Hello friends, Please find attachment of array & simple formulae. Thnx Karan www.karanxel.blogspot.com * Kαяαη* On Tue, Jul 26, 2011 at 12:27 PM, Venkat CV wrote: > Dear All, > > any one Explain Difference between Array formula and Normal Formula... > > With Examples..&Use of Array formu

Re: $$Excel-Macros$$ Merge Vertically

eCells = True > End With > End Sub > > On Fri, Jul 15, 2011 at 12:56 PM, karan 1237 wrote: > >> Hello Friends, >> >> Once again I need your help. There is option for merge across in excel but >> is there any macro to merge vertically. It wil

$$Excel-Macros$$ Merge Vertically

Hello Friends, Once again I need your help. There is option for merge across in excel but is there any macro to merge vertically. It will merge selected range in vertically. Thnx Karan -- -- Some important links fo

Re: $$Excel-Macros$$ Need a Macro

It's working...Thank you so much... * Kαяαη* On Fri, Jul 15, 2011 at 12:33 PM, NOORAIN ANSARI wrote: > > http://www.excelforum.com/excel-programming/353482-macro-to-create-format-painter.html > > > On Fri, Jul 15, 2011 at 12:29 PM, karan 1237 wrote: > >> Hello Fr

$$Excel-Macros$$ Need a Macro

Hello Friends, I need your help to make macro. I need a macro which work like format painter for different format not only one format. * --- Kαяαη* -- -- Some important links for excel users: 1. Follow us on TWITTER

Re: $$Excel-Macros$$ Numbering

Hey ankur, I want to ask something Sub test() Sheet1.Range("A2:A15").Clear Dim i, j As Long Range("a1").Value = InputBox("put your value") For i = 1 To Sheets(1).Cells(1, 1).Value Cells(i + 1, 1).Value = i Next i End Sub In this code what is "i" & "j" ? * Kαяαη* On Mon, Jul 11, 201

Re: $$Excel-Macros$$ Need a book

s@googlegroups.com] *On Behalf Of *karan 1237 > *Sent:* Tuesday, July 12, 2011 2:32 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Need a book > > ** ** > > ** ** > > Hi Group Users, > > > I need your help, I need a book of excel *&qu

$$Excel-Macros$$ Need a book

Hi Group Users, I need your help, I need a book of excel *"101 secrets of a microsoft excel addict".* If you have full version of this book please send me. Thnx Karan -- -- Some important links for excel users: 1. F

$$Excel-Macros$$ Need a book

Hi Group Users, I need your help, I need a book of excel *"101 secrets of a microsoft excel addict".* I you have full version of this book please send me. Thnx Karan -- -- Some important links for excel users: 1. Fo

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

It's great...!!! *--- кαяαηη* On Wed, Jul 6, 2011 at 3:49 PM, NOORAIN ANSARI wrote: > Dear Jai, > > Please try it without helping column.. > > =VLOOKUP(B7&"*",Sheet1!B7:C12,2,) > > > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ Congratulations Ashish Koul....!!!

First of all Congratulations Ashish Sir Ji for MVP Award. I already knew that you'll definitely got this award. Thnx for your co operation & helps. You solved our problems very well & gave us good knowledge of excel. I got inspiration from you. Last but not least I thank to Ayush Sir who has c

Re: $$Excel-Macros$$ Automatically Hyperlink

hanks, > saber > > On Tue, Jun 7, 2011 at 1:40 PM, karan 1237 wrote: > >> Hello Experts, >> >> I need your assistance. I'v a workbook which has 4 sheet. I want to create >> a automatically hyperlink (through formulae) when I change content of cell >> a2

$$Excel-Macros$$ Automatically Hyperlink

Hello Experts, I need your assistance. I'v a workbook which has 4 sheet. I want to create a automatically hyperlink (through formulae) when I change content of cell a2, hyperlink automatically should change...Please help me. Thnx *--- кαяαηη* --

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

t all vba cod and passwrod request will not work than sheet > will open and go to refrance pswlist and you will show all pass and than go > to vba auditor and show code and user form > thx and best wishes > gomaa. > > > On 2 June 2011 14:24, karan 1237 wrote: > >> Thnx a

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

Thnx a lot Rajan. You are most helpful persongreat... :) *--- кαяαηη* On Thu, Jun 2, 2011 at 5:37 PM, Rajan_Verma wrote: > Hi Karan, > > I think it has been Complete Now…. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

αηη,* > > *Greetings for the day!!!* > > *to protect your sheet or workbook go to review pane in office 2007, then > protect sheet, then limit of protection. by doing this u can protect ur > project with a password.* > > > > Regards > > Vishal Gupta > > > &g

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

can protect ur > project with a password.* > > ** > Regards > Vishal Gupta > > > > On Wed, Jun 1, 2011 at 3:58 PM, karan 1237 wrote: > >> >> Hello Expert >> >> I need your help to to create conditions & password protection in my >> pr

$$Excel-Macros$$ Please help to make my project good.

Respected Sirs/Mam, I need your help making my project good. Please find attachment. I will be very obliged if someone can help me as earlier as possible. -- Basically I have to do that when I click on drop down list & select another career i.e. Building and Construction so In sub career

Re: $$Excel-Macros$$ Please Help

quot; > End If >Next Cel >If Len(Tx) > 0 Then Tx = Left(Tx, Len(Tx) - 2) >If Len(Tx) > 0 Then Tx = Right(Tx, Len(Tx) - 2) >UniqueList = Tx > End Function > > > > On Sat, May 7, 2011 at 3:50 PM, karan 1237 wrote: > >> * >>

$$Excel-Macros$$ Please Help

* LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT FRONT *Hi Experts, I want like this. Please help. Thnx in Advance. * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı -- ---

$$Excel-Macros$$ Pls Help...

*Hi.. Experts & Excel guru I need ur help.. pls help me.. Thnx Karan * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : ht

Re: $$Excel-Macros$$ Pls Help..

*Thnx.. * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı On Thu, Feb 24, 2011 at 10:15 AM, Rohan Young wrote: > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > 2011/2/23 кαяαηη yα∂αν > > >> To post to this group, send email to excel-macros@googlegroups.com >> > >