date:20170228

$$Excel-Macros$$ Find and Replace Exact String in delimited cell with list of values

2017-02-28 Thread imelda1ab

I found the following code that does precisely what I need it to do EXCEPT 
I need to modify it so that it reviews all values in a delimited cell (;). 
 The code I had been using works great for the first instance of a match, 
but for the purposes of a new project, I need it to be an exact match. 
 Thank you in advance for any and all assistance and pointers!

Find Value   Replace with Value  Values to be 
Changed:
REL000329 ATI-36_0001   
 REL000329.0001;REL000329.0002
REL000329.0001 ATI-37_0001
REL000329.0002 ATI-38_0001


Option Explicit
Sub Multi_FindReplace()
Dim sRng As Range, InputRng As Range, ReplaceRng As Range, Cls As 
Range, Rg0 As Range
Dim MyAdd$, xTitleId$

xTitleId = "ERS : Applying Abbreviation"
Set InputRng = Application.Selection
Set InputRng = Application.InputBox("Select the Columns to Apply 
Standards ", xTitleId, InputRng.Address, Type:=8)
Set ReplaceRng = Application.InputBox("Standard Abbreviations Sheet 
Range (Col A and ColB):", xTitleId, Type:=8)
 Application.ScreenUpdating = False

For Each Cls In ReplaceRng.Columns(1).Cells
 Set sRng = InputRng.Find(Cls.Value, , xlFormulas, xlWhole)
 If Not sRng Is Nothing Then 
 MyAdd = sRng.Address
 Do
 If Rg0 Is Nothing Then
  Set Rg0 = sRng
 Else
  Set Rg0 = Union(Rg0, sRng)
End If

 Set sRng = InputRng.FindNext(sRng)
 Loop While Not sRng Is Nothing And sRng.Address <> MyAdd
End If

If Not Rg0 Is Nothing Then
 Rg0.Value = Cls.Offset(, 1).Value
 Set Rg0 = Nothing
End If
 Next Cls

Application.ScreenUpdating = True
End Sub



-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

2017-02-28 Thread Mohd Sadiq

Firstly Unhide the sheet , and  I need Shift wise Staffing / Present basis
of business shift which is mentioned in "A" column

I had made Normal some / Split shift details in shared shift however I m
getting error in Night Shift when I m trying to used same formula .

Regards,
Sadiq
979223

On Tue, Feb 28, 2017 at 9:52 PM, Pankaj Sharma 
wrote:

> Didn't get your query, what you want to do in this sheet, pls mention
> example with result.
>
>
>
> *PJ  *
>
> *MIS Analyst*
>
>
> *Greater Kailash-1, New Delhi.*
>
> *Instagram*  *pj_sharma_*
>
> *Tweeter*
> *dude_sharma_pj**Facebook**   www.facebook.com/dude.pj
> *
>
>
> *We meet for a reason, either you're a blessing or a lesson...*
>
> On Tue, Feb 28, 2017 at 9:22 PM, Mohd Sadiq 
> wrote:
>
>> Hello Team ,
>>
>>
>>
>>
>> Hope you are doing well,
>>
>>
>>
>> Here is attached a file where I need Interval / Day wise staffing which
>> is mentioned in “H” Column, I am trying it multiple times to fixed Night
>> Shift issue but unfortunately I’m not getting resolution L
>>
>>
>>
>> Request you to Pls help on the same on priority.
>>
>>
>>
>>
>>
>>
>> Regards
>> Mohd Sadiq
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 



Regards
Mohd Sadiq
979223

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

2017-02-28 Thread storeythomas725 via MS EXCEL AND VBA MACROS

On Tue, 2/28/17, Pankaj Sharma  wrote:

 Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
 To: excel-macros@googlegroups.com
 Date: Tuesday, February 28, 2017, 6:22 PM

 Didn't
 get your query, what you want to do in this sheet, pls
 mention example with result.
 PJ        

   MIS
 Analyst
     Greater
 Kailash-1, New Delhi.
 Instagram  pj_sharma_Tweeter 
  dude_sharma_pj
 Facebook   www.facebook.com/dude.pj  We meet
 for a reason, either you're a blessing or a
 lesson...

 On Tue, Feb 28, 2017 at
 9:22 PM, Mohd Sadiq 
 wrote:
 Hello Team ,

 Hope you are doing
 well,

 Here is attached a file
 where I need Interval / Day wise
 staffing which is mentioned in “H” Column, I am trying
 it multiple times to fixed
 Night Shift issue but unfortunately I’m not getting
 resolution L

 Request you to Pls help on the same
 on priority.

 Regards
 Mohd Sadiq

 -- 

 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/
 discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.

 2) Don't post a question in the thread of another
 member.

 3) Don't post questions regarding breaking or bypassing
 any security measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Jobs posting is not allowed.

 6) Sharing copyrighted material and their links is not
 allowed.

 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.

 --- 

 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.

 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscribe@
 googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.

 Visit this group at https://groups.google.com/
 group/excel-macros.

 For more options, visit https://groups.google.com/d/
 optout.

 -- 

 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.

 2) Don't post a question in the thread of another
 member.

 3) Don't post questions regarding breaking or bypassing
 any security measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Jobs posting is not allowed.

 6) Sharing copyrighted material and their links is not
 allowed.

 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.

 --- 

 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.

 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.

 Visit this group at https://groups.google.com/group/excel-macros.

 For more options, visit https://groups.google.com/d/optout.
 econstituiti armata refacand cadrele si armamentul.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Count Number Frequency

2017-02-28 Thread Abhishek Kumar Tanwar

Dear All,

Any update on this query.

Pls help.


Thanks
Abhishek

On Mon, Feb 27, 2017 at 11:45 AM, Abhishek Kumar Tanwar <
abhishekkumartanw...@gmail.com> wrote:

> Dear All,
>
> Want to know, how many calls are drop in 24 hrs, 48 hrs and after 48 hrs
> by each mobile number.
>
> Sheet is attached. Pls help in this query.
>
>
> Thanks
> Abhishek
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/excel-macros/FnI2xLeCt6Y/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Ref: IMMEDIATE ON BOARD

2017-02-28 Thread Antony Raj

Hello,

I have completed as SAP Security and GRC - Architect & Analyst, and I would
like to On Board Immediately ASAP. I am very much experienced to my
respective professional field. Please update me with the best
opportunities.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Antony Raj.doc
Description: MS-Word document

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

2017-02-28 Thread Pankaj Sharma

Didn't get your query, what you want to do in this sheet, pls mention
example with result.



*PJ  *

*MIS Analyst*


*Greater Kailash-1, New Delhi.*

*Instagram*  *pj_sharma_*

*Tweeter*
*dude_sharma_pj**Facebook**   www.facebook.com/dude.pj
*


*We meet for a reason, either you're a blessing or a lesson...*

On Tue, Feb 28, 2017 at 9:22 PM, Mohd Sadiq  wrote:

> Hello Team ,
>
>
>
>
> Hope you are doing well,
>
>
>
> Here is attached a file where I need Interval / Day wise staffing which is
> mentioned in “H” Column, I am trying it multiple times to fixed Night Shift
> issue but unfortunately I’m not getting resolution L
>
>
>
> Request you to Pls help on the same on priority.
>
>
>
>
>
>
> Regards
> Mohd Sadiq
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: same name

2017-02-28 Thread martinez.david533 via MS EXCEL AND VBA MACROS

On Tue, 2/28/17, Paul Schreiner  wrote:

 Subject: Re: $$Excel-Macros$$ Re: same name
 To: "excel-macros@googlegroups.com" 
 Date: Tuesday, February 28, 2017, 2:22 PM

 Your
 question is extremely vague.
 The
 simple answer is: yes.
 Simply
 use find/replace (ctrl-h)enter JAY
 BHAVANI COAL FILEDS PVT. LTD. in the "find what:"
 fieldenter
 Jay Bhawani Coal Fields Pvt Ltd  in the "Replace
 with:" fieldand click the
 "Replace All" button.
 Is
 THAT what you're looking to do?(because
 that's what you asked)
 BTW: you changed BhaVani
 to BhaWani
 Paul-
 “Do all the
 good you can,
 By all the means you can,
 In all the ways you can,
 In all
 the places you can,
 At all the times you
 can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 -

On Tuesday, February
 28, 2017 5:36 AM, "jignesh.audichy...@gmail.com"
  wrote:

          can i make it only one
 type of name like JAY BHAVANI COAL FILEDS PVT. LTD. to Jay
 Bhawani Coal Fields Pvt Ltd for all the name 

 On
 Friday, February 24, 2017 at 2:13:18 PM UTC+5:30, jignesh
 audichya wrote:respected all ,
 is
 there any way to make the two or more name same if all that
 name have the small diff like ,.'

 -- 
 Warm Regards,
 Jignesh
 Audichya.

 -- 

 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.

 2) Don't post a question in the thread of another
 member.

 3) Don't post questions regarding breaking or bypassing
 any security measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Jobs posting is not allowed.

 6) Sharing copyrighted material and their links is not
 allowed.

 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.

 --- 

 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.

 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.

 Visit this group at https://groups.google.com/group/excel-macros.

 For more options, visit https://groups.google.com/d/optout.

 -- 

 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
 wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
 Facebook page of this forum @ https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles,
 like Please Help, Urgent, Need Help, Formula Problem, Code
 Problem, and Need Advice will not get quick attention or may
 not be answered.

 2) Don't post a question in the thread of another
 member.

 3) Don't post questions regarding breaking or bypassing
 any security measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Jobs posting is not allowed.

 6) Sharing copyrighted material and their links is not
 allowed.

 NOTE  : Don't ever post confidential data in a workbook.
 Forum owners and members are not responsible for any
 loss.

 --- 

 You received this message because you are subscribed to the
 Google Groups "MS EXCEL AND VBA MACROS" group.

 To unsubscribe from this group and stop receiving emails
 from it, send an email to excel-macros+unsubscr...@googlegroups.com.

 To post to this group, send email to excel-macros@googlegroups.com.

 Visit this group at https://groups.google.com/group/excel-macros.

 For more options, visit https://groups.google.com/d/optout.
 Care a fost statutul politic al Transilvaniei in cadrul regimului dualist 
austro-ungar?

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this

Re: $$Excel-Macros$$ Re: same name

2017-02-28 Thread Paul Schreiner

Your question is extremely vague.
The simple answer is: yes.
Simply use find/replace (ctrl-h)enter JAY BHAVANI COAL FILEDS PVT. LTD. in the 
"find what:" fieldenter Jay Bhawani Coal Fields Pvt Ltd  in the "Replace with:" 
fieldand click the "Replace All" button.
Is THAT what you're looking to do?(because that's what you asked)
BTW: you changed BhaVani to BhaWani
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
- 

On Tuesday, February 28, 2017 5:36 AM, "jignesh.audichy...@gmail.com" 
 wrote:
 

 
         can i make it only one type of name like JAY BHAVANI COAL FILEDS PVT. 
LTD. to Jay Bhawani Coal Fields Pvt Ltd for all the name 




On Friday, February 24, 2017 at 2:13:18 PM UTC+5:30, jignesh audichya wrote:
respected all ,
is there any way to make the two or more name same if all that name have the 
small diff like ,.'

-- 
Warm Regards,
Jignesh Audichya.
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


   

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: same name

2017-02-28 Thread jignesh . audichya24

 can i make it only one type of name like JAY BHAVANI COAL FILEDS 
PVT. LTD. to Jay Bhawani Coal Fields Pvt Ltd for all the name 

On Friday, February 24, 2017 at 2:13:18 PM UTC+5:30, jignesh audichya wrote:
>
> respected all ,
>
> is there any way to make the two or more name same if all that name have 
> the small diff like ,.'
>
> -- 
> Warm Regards,
>
> Jignesh Audichya.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

my file.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: same name

2017-02-28 Thread jignesh . audichya24

On Friday, February 24, 2017 at 2:13:18 PM UTC+5:30, jignesh audichya wrote:
>
> respected all ,
>
> is there any way to make the two or more name same if all that name have 
> the small diff like ,.'
>
> -- 
> Warm Regards,
>
> Jignesh Audichya.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Find and Replace Exact String in delimited cell with list of values

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

Re: $$Excel-Macros$$ Count Number Frequency

$$Excel-Macros$$ Ref: IMMEDIATE ON BOARD

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

Re: $$Excel-Macros$$ Re: same name

Re: $$Excel-Macros$$ Re: same name

$$Excel-Macros$$ Re: same name

$$Excel-Macros$$ Re: same name

10 matches

Site Navigation

Mail list logo

Footer information