-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
replace string
-
B
UDF VBA - Multiple Replacements of Substrings in a String to ""
New to the forum. I'm stuck on this replacement loop. Function CCL2(ByRef txt As String, ByRef x As String) ' txt as starting text ' x as cell containing array that can be split by " " (space character) ' y as a String Array Dim y() As String ' split x into array by " " y =...- bcbsmith
- Thread
- array array compare replace replace string user defined function
- Replies: 3
- Forum: Excel Questions
-
E
VBA Excel Help: Replace(String, Find, Replace) Not Working on Other Computers
It is working on mine just fine however. I tried to make sure the references match up on each computer and they seem to. It seems to be just deleting the find string and not adding in the replace string. For Example: ... x = "I like oranges." y = Replace(x,"Oranges","Apples") msgbox y ... y...- ErockF
- Thread
- excel replace string vba
- Replies: 0
- Forum: Excel Questions
-
Q
Stripping out certain words from start of cells
Hi I'm new to this forum, and hope someone might be able to help me. I have a range of about 5000 rows, each representing a title of an article, and I need to be able to strip out the words "The ", "Les", "A ", "Le ", "La " or "An " if they are at the start of each title. So e.g. I start with...- qetzel
- Thread
- replace string replace text
- Replies: 10
- Forum: Excel Questions
-
J
Replace all text before a specific word in cell B1 with text string in cell A1?
Any Excel Guru's out there that could provide me with a formula? I would like to replace all the text before the word "for" in cell B1 with the text string in A1. Cell A1 has proper casing and an added space after "Handle".- john deer
- Thread
- replace characters replace string update info
- Replies: 2
- Forum: Excel Questions
-
S
Converting a string into a particular Date Format
I have a large no of strings(left hand side of arrow) and i need to convert them into Date format(right hand side of arrow) in Excel. 19,690,408 --->> 04/08/1969 19,610,419 --->> 04/19/1961 19,560,107 --->> 01/07/1956 Can anyone help me with this? Thanks in advance.- sahilmadan
- Thread
- date remove characters replace string string formating
- Replies: 17
- Forum: Excel Questions
-
J
How to replace/delete all charaters that appear after '/'
I have a spreadsheet showing variable strings however I want to remove all character that appear after / e.g 'Virgin Islands/123/7 H %' should appear as just 'Virgin Islands'. The strings and the characters after the '/' are variable in length so the replace function using '/????' will not work...- jnathan
- Thread
- delete string remove characters replace string
- Replies: 6
- Forum: Excel Questions
-
K
Pattern Matching in Find/ Replace VBA Excel
Hi, First of all I am trying to replace a part of a string in a list of data e.g. EXP4200-1 EXP4200-2 EXP4200-5 EXP4200-25 EXP4000-2 EXP4000-3 EXP3080-12 EXP3080-105 EXP3080-106 ... I want to delete (or replace with "") the 'EXP####-' part of the string, however I dont know how to use the...- killpaddy
- Thread
- excel find & replace pattern matching replace string vba
- Replies: 4
- Forum: Excel Questions
-
R
How do i Substitue second occurrence of a string within a cell?
Hello, Could anyone suggest how do i Substitue second occurrence of a string within a cell? Cell A1: Port Size","","Female Port Size","1/8" I want to substitute the second occurrence of this "," string with |(pipe). Please suggest me a formula for this. Regards, Raj- rajtak
- Thread
- replace string second occurrence second string subsitute
- Replies: 2
- Forum: Excel Questions
