Re: $$Excel-Macros$$ How to find special characters in a cell

simply if you want to forbid those special characters while entering in the cell use the below formula in validation rule =LEN(A1)=LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"/",""),"\",""),"*",""),"?",""),"<",""),">",""),"|",""),,"")) ask m

Re: $$Excel-Macros$$ How to find special characters in a cell

place the name on a1 below formula should work with CSE =IF(SUM(IFERROR(FIND({"/","\","?","<",">","|","*",},A1),""))>0,"Wrong","Ok") On Wed, Jan 2, 2013 at 8:34 PM, wrote: > In excel 2012 I'm using the name typed in a cell as a part of the filename > when saved via a macro. > Because the fol

$$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

Hi Rashid, The file which i have sent you contains a sheet named *Sample *so if you have copied only the code then it will give you an error because the sheet is not available. Please check the same. Reagrds, Lalit Mohan On Thursday, 3 January 2013 00:57:11 UTC+5:30, prkhan56 wrote: > > Hello

Re: $$Excel-Macros$$ Lookup and Replace

PFA On Thu, Jan 3, 2013 at 10:27 AM, The Viper wrote: > slightly modified your code. > check the attachment > > > On Thu, Jan 3, 2013 at 8:47 AM, Awal wrote: > >> Hello, >> I would like to wish y'all a Happy New year... >> I am still learning VBA and I really need help: >> I want to be able to

Re: $$Excel-Macros$$ VBA code for copying bitmap image into outlook

Dear Satheeshkumar, Find the below image, it might be it will help to write a code, here i dont have excess to outlook. press the circle option it will show you clipboard then you can paste it into outlook. Thanks & Regards, Prajakt Pande +971551388482 ** On Thu, Jan 3, 2013 at 9:06 AM, Sathe

Re: $$Excel-Macros$$ Lookup and Replace

slightly modified your code. check the attachment On Thu, Jan 3, 2013 at 8:47 AM, Awal wrote: > Hello, > I would like to wish y'all a Happy New year... > I am still learning VBA and I really need help: > I want to be able to look up for an item and change its price. > See attached file.Can some

$$Excel-Macros$$ VBA or VSTO

Hi, What is the best option now, VBA or VSTO? Also can you give me its advantages/drawbacks over each other. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread t

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

Hi Viper, No issue.. :) i am not pointing you just letting you know. thanks for the nice formula. Regards, Lalit Mohan On Thursday, 3 January 2013 09:49:40 UTC+5:30, §»VIPER«§ wrote: > > Hi lalit > > I don't find any need for that. just working as required by OP > > On Wed, Jan 2, 2013 at 3

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

Hi lalit I don't find any need for that. just working as required by OP On Wed, Jan 2, 2013 at 3:15 PM, Lalit Mohan Pandey wrote: > Nice formula viper but the last space is missing. > > > On Wednesday, 2 January 2013 15:07:20 UTC+5:30, §»VIPER«§ wrote: > >> =LEFT(A1,MIN(IFERROR(FIND({0,**1,2,3,

$$Excel-Macros$$ Lookup and Replace

Hello, I would like to wish y'all a Happy New year... I am still learning VBA and I really need help: I want to be able to look up for an item and change its price. See attached file.Can someone please help? Thanks. -- Join official Facebook page of this forum @ https://www.facebook.com/discus

$$Excel-Macros$$ Re: How to find special characters in a cell

Here's one way to do it in a formula: use this website ( ascii-code.com ) to look up the ASCII equivalent of each character. It turns out to be this: /47 \92 *42 ?63 "34 <60 >62 |124 Then use a FIND formula to look for the ASCII equivalent. I tried the SEARCH form

$$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

Hello Lalit, I tried the macro and it works perfectly on the sample data I uploaded in my first post. But very very sorry, I missed to say that Col A has date/Time ad Col B has the Name and not the other way round. Can the code be amended accordingly please. However, if I run your code by i

Re: $$Excel-Macros$$ How to find special characters in a cell

Hi Danny, May be this code will work for you: *Private Sub Worksheet_SelectionChange(ByVal Target As Range)* * * *If Target.Resize(1, 1) = ThisWorkbook.Worksheets("JIBase").Range("G4") Then* *If Len(Trim(Target.Resize(1, 1).Value)) <> 0 Then* *If Not CreateFile(Target.Res

Re: $$Excel-Macros$$ How to find special characters in a cell

can you share workbook? On Wed, Jan 2, 2013 at 8:34 PM, wrote: > In excel 2012 I'm using the name typed in a cell as a part of the filename > when saved via a macro. > Because the following characters /\*?"<>| are not allowed in a filename I > want to do a check in the cell. > The idea is to pu

$$Excel-Macros$$ Re: Introduce Yourself !!

Hello All, My name is Danny Mariens and I work as a crewplanner in Belgium. The company I work for is PRG with offices around the world. I'm working in excel all day because this is our only planningtool. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORU

$$Excel-Macros$$ How to find special characters in a cell

In excel 2012 I'm using the name typed in a cell as a part of the filename when saved via a macro. Because the following characters /\*?"<>| are not allowed in a filename I want to do a check in the cell. The idea is to put a warning in a free cell that the name isn't allowed when it contains on

Fwd: $$Excel-Macros$$ Re: Please unsuscribe

*To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com* -- Forwarded message -- From: Praveen Golash Date: Wed, Jan 2, 2013 at 5:36 PM Subject: $$Excel-Macros$$ Re: Please unsuscribe To: excel-macros@googlegroups.com To unsubscribe from this gr

Re: $$Excel-Macros$$ Re: Happy b'day Noorain Ansari

Thanks to all of You... -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com On Wed, Jan 2, 2013 at 12:

Re: $$Excel-Macros$$ Happy b'day Noorain Ansari

Thanks to all of you... On Wed, Jan 2, 2013 at 12:44 PM, wrote: > Happy Birthday big bro > Sent from my BlackBerry® smartphone from Airtel Ghana > > -Original Message- > From: koul.ash...@gmail.com > Sender: excel-macros@googlegroups.com > Date: Tue, 1 Jan 2013 18:43:59 > To

$$Excel-Macros$$ Re: Please unsuscribe

Please unsubscribe On Wed, Jan 2, 2013 at 10:25 AM, Praveen Golash wrote: > Please do the needful. > > -- > Regards, > > Praveen Golash > > -- Regards, Praveen Golash KPMG Advisory Services Pvt. Ltd. Mobile: +91- 9711302259 -- Join official Facebook page of this forum @ https://www.facebo

Re: $$Excel-Macros$$ Excel Fun Video *

Love this why did he choose the choosen one level On Jan 1, 2013 10:48 AM, "amar takale" wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (amartak...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

Nice formula viper but the last space is missing. On Wednesday, 2 January 2013 15:07:20 UTC+5:30, §»VIPER«§ wrote: > > =LEFT(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),""))-1)&SUBSTITUTE(MID(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),"")),255)," > > ","") > > this should work with CSE > >

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

=LEFT(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),""))-1)&SUBSTITUTE(MID(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),"")),255)," ","") this should work with CSE On Wed, Jan 2, 2013 at 2:55 PM, Pravin Gunjal wrote: > It's absolutely working fine. > > Pravin Gunjal > > > -- Forwarded

Fwd: $$Excel-Macros$$ Re: how to remove space between numbers only.

It's absolutely working fine. Pravin Gunjal -- Forwarded message -- From: Prince Date: Wed, Jan 2, 2013 at 11:20 AM Subject: $$Excel-Macros$$ Re: how to remove space between numbers only. To: excel-macros@googlegroups.com Hi Manoj, use this this may help you incase if the Num

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

Hi, Sorry for the long formula if sombody found somthing in short please let me know ;) If value is in cell A1 paste below code on cell A2 with Ctrl + Shift + Enter =REPLACE(A1,MATCH(1,N(ISNUMBER(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),4,0)+1,MAX(N(ISNUMBER(VALUE(MID(A1,ROW(INDIRECT("1:"&

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

Thanks Anoop Will come back to u after reading the books,if I don't get anything shall I ask u for better clarification Sent from my BlackBerry® smartphone from !DEA -Original Message- From: Anoop K Sharma Sender: excel-macros@googlegroups.com Date: Wed, 2 Jan 2013 14:26:36 To: Reply

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

Hi Priyanka, You can refer some good e-books. Why don't you try this on bookboon.com. As a beginner you should go with "Excel Bible", this will teach you not only excel basics but also VBA at initial stage. Regards, Anoop Sr. Developer On Wed, Jan 2, 2013 at 2:18 PM, Manoj Kumar wrote: > Wow!

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

Wow!! Thank you very much. Problem solved.. On Wednesday, 2 January 2013 14:10:36 UTC+5:30, Enrique Martin wrote: > > Replace the code with following one. Remember you are concatenating text > and Numeric. > > Find attached the updated one > > > Function RemoveSpaces(str As String) As String >

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

Beginning to like it in this group. It works but would have preferred if text was returned also Francis Mukobi Frank Web Hosts Your affordable & quality web hosts http://frankhost.net Phone: +256 752 954 723 For every domain you purchase from us, we host your website for the first 3 months for