| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace text in specific column
Hi,
I am trying to write a macro that replaces the word MAR into MRT for column E and in the range 2:250 Doe sanyone has that code for me? It would help me very much. Best regards, Gijs |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace text in specific column
Sub ReplaceData()
Range("E2:E250").Replace _ What:="MAR", _ Replacement:="MRT", _ LookAt:=xlPart, _ SearchOrder:=xlByRows, _ MatchCase:=False End Sub -- Regards, Tom Ogilvy "Gijs Breedveld" wrote in message ... Hi, I am trying to write a macro that replaces the word MAR into MRT for column E and in the range 2:250 Doe sanyone has that code for me? It would help me very much. Best regards, Gijs |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace text in specific column
This really worked.
Thanks. Regards, Gijs Breedveld "Tom Ogilvy" wrote: Sub ReplaceData() Range("E2:E250").Replace _ What:="MAR", _ Replacement:="MRT", _ LookAt:=xlPart, _ SearchOrder:=xlByRows, _ MatchCase:=False End Sub -- Regards, Tom Ogilvy "Gijs Breedveld" wrote in message ... Hi, I am trying to write a macro that replaces the word MAR into MRT for column E and in the range 2:250 Doe sanyone has that code for me? It would help me very much. Best regards, Gijs |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace text in specific column
Gijs
Try this Sub ReplaceMAR() Range("E2:E250").Replace What:="MAR", Replacement:="MRT" End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Gijs Breedveld" wrote in message ... Hi, I am trying to write a macro that replaces the word MAR into MRT for column E and in the range 2:250 Doe sanyone has that code for me? It would help me very much. Best regards, Gijs |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace text in specific column
This also works great.
Thanks, Regards, Gijs Breedveld "Nick Hodge" wrote: Gijs Try this Sub ReplaceMAR() Range("E2:E250").Replace What:="MAR", Replacement:="MRT" End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Gijs Breedveld" wrote in message ... Hi, I am trying to write a macro that replaces the word MAR into MRT for column E and in the range 2:250 Doe sanyone has that code for me? It would help me very much. Best regards, Gijs |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace text in specific column
Sub Macro1()
Range("E2:E250").Select Selection.Replace What:="MAR", Replacement:="MRT" End Sub -- Gary's Student "Gijs Breedveld" wrote: Hi, I am trying to write a macro that replaces the word MAR into MRT for column E and in the range 2:250 Doe sanyone has that code for me? It would help me very much. Best regards, Gijs |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace text in specific column
This also works great.
Thanks, Regards, Gijs Breedveld "Gary''s Student" wrote: Sub Macro1() Range("E2:E250").Select Selection.Replace What:="MAR", Replacement:="MRT" End Sub -- Gary's Student "Gijs Breedveld" wrote: Hi, I am trying to write a macro that replaces the word MAR into MRT for column E and in the range 2:250 Doe sanyone has that code for me? It would help me very much. Best regards, Gijs |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Column after specific text title the new column and add for | Excel Discussion (Misc queries) | |||
| Find & Replace - Limit search to a specific column | Excel Worksheet Functions | |||
| How can I replace text with a specific number? | Excel Discussion (Misc queries) | |||
| FIND SPECIFIC TEXT AND REPLACE IT | Excel Worksheet Functions | |||
| Macro to search a column for a specific word and replace with | Excel Programming | |||
Hybrid Mode
