Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 11-11-2015, 08:25 AM
manilara manilara is offline vba to replace old value by target value search almost key words matching Windows 7 32bit vba to replace old value by target value search almost key words matching Office 2007
Banned
vba to replace old value by target value search almost key words matching
 
Join Date: Apr 2015
Posts: 7
manilara is on a distinguished road
Default vba to replace old value by target value search almost key words matching

Dear experts



I have data in column D Header value is Source:

I have to align the values proper format like My target is CSV File But it has like CSV or CSV_File or CSV File so it got mis appropriate values of text in col
My target is CSV File from where find CSV
2nd target is Manual - CBT from where ever find CBT change as Manual - CBT
3rd target is Web Adi from where ever find Web or Adi or Web_Adi,wEb adi like
In 3rd condition main criteria is Web Adi MC_MT should not be change it should be as it is

Pls do needful find the attachment.

Last edited by manilara; 11-11-2015 at 08:27 AM. Reason: reason
  #2  
Old 11-11-2015, 12:30 PM
charlesdh charlesdh is offline vba to replace old value by target value search almost key words matching Windows 7 32bit vba to replace old value by target value search almost key words matching Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

Hi,

Can you attach the file?
  #3  
Old 11-12-2015, 02:41 AM
manilara manilara is offline vba to replace old value by target value search almost key words matching Windows 7 32bit vba to replace old value by target value search almost key words matching Office 2007
Banned
vba to replace old value by target value search almost key words matching
 
Join Date: Apr 2015
Posts: 7
manilara is on a distinguished road
Default

How to attach file pls advice sir
  #4  
Old 11-12-2015, 02:42 AM
manilara manilara is offline vba to replace old value by target value search almost key words matching Windows 7 32bit vba to replace old value by target value search almost key words matching Office 2007
Banned
vba to replace old value by target value search almost key words matching
 
Join Date: Apr 2015
Posts: 7
manilara is on a distinguished road
Default

how to attach the file sir? i tried but it did work
Attached Images
File Type: png WEST.png (58.3 KB, 18 views)
  #5  
Old 11-15-2015, 06:14 PM
charlesdh charlesdh is offline vba to replace old value by target value search almost key words matching Windows 7 32bit vba to replace old value by target value search almost key words matching Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

Hi,

Click the "Go Advance".
When the form opens scroll down and you will see

"Manage Attachments"
Click on it.
When the next screen opens you will see "Upload file from your computer"
Click on Chose file and then follow prompts.

This should get you started.
  #6  
Old 11-16-2015, 05:17 AM
manilara manilara is offline vba to replace old value by target value search almost key words matching Windows 7 32bit vba to replace old value by target value search almost key words matching Office 2007
Banned
vba to replace old value by target value search almost key words matching
 
Join Date: Apr 2015
Posts: 7
manilara is on a distinguished road
Default vba to replace old value by target value search almost key words matching Reply to Thread

Hi sir

pls find the attachment
Attached Files
File Type: xlsx coloring-1.xlsx (335.7 KB, 8 views)
  #7  
Old 11-19-2015, 08:19 PM
macropod's Avatar
macropod macropod is offline vba to replace old value by target value search almost key words matching Windows 7 64bit vba to replace old value by target value search almost key words matching Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Cross-posted at:
http://www.excelforum.com/excel-prog...-matching.html
and:
http://www.mrexcel.com/forum/excel-q...-matching.html
and:
http://www.utteraccess.com/forum/ind...wtopic=2032852
and:
http://www.access-programmers.co.uk/....php?p=1460505
and:
http://www.excelguru.ca/forums/showt...words-matching
and:
http://excelexperts.com/vba-replace-...words-matching

Talk about abusing the help community!!!

For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

Thread closed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Closed Thread



Similar Threads
Thread Thread Starter Forum Replies Last Post
Search the words of different document Sandhya Word 15 11-24-2014 01:29 PM
vba to replace old value by target value search almost key words matching Search for italicized words ep2002 Word 4 11-10-2014 10:23 PM
Multiple words, one search return2300 Word VBA 0 08-30-2013 12:26 PM
Search and Replace - Clear Search box JostClan Word 1 05-04-2010 08:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft