replace characters

Hi there, Trying to convert text within one cell to a simplified version. For example, I have a cell that reads "UK Fund Mid-Cap Blend" but I want to convert this to "Mid Blend". Right now, I am using the below formula to strip "UK Fund Mid-Cap Blend" down to "Mid-Cap Blend". cell C9...

HOW DO I GET THE * TO CHANGE TO (a) in superscript. Need the parentheses as well. I tried the replace button, it replaces the whole word as well. I have multiple large files and trying to find the most efficient method For example, i want it to look like this

Hi Folks, I have a list of customers in column A. All of them start with "zz" which is simple enough to remove using... Range("A2:A" & lRow).Replace what:="zz", Replacement:="", _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=True, _ SearchFormat:=False...

Hi, i could really use some help with this. i have this code that checks a column for an illegal character (for sheet name) and replaces it with "_". I want it to check for the fill list of characters that are not allowable sheet names .Pattern = "[\<\>\*\\\/\?|]" Sub...

I have words in a cell separated by a semicolon and need a macro to replace the ";" and put the words in a alpha list within the cell have this: black;blue;green;red;purple want this: black blue green purple red

Hi, i am new in this forum. First sorry my poor english. I'm trying to put together a macro that looks for a specific character and replace it with another one that is located in another column of the same line. Example <tbody> Column A Column B Column C Column D 11/05/2018 Z123456...

Hi, I have quite a few large spreadsheets that contain unique reference numbers (both text and numbers) that I need to convert to a new format. Examples of current text number formats: ABC.1-235 LD.12-1 XYZ.356-12 Examples of what need converting to: ABC00001.235 LD00012.1 XYZ00356.12 If...

I need to remove the forward slashes and leave the results in a data set like the below. I keep losing the leading zeros when I do a replace all with / in the find and left the replace with blank even when the cells are formatted to Text. I am working in Excel 2010 with a regular .xlsx file - I...

Hello, I am trying to edit a long spreadsheet, I try to search and replace a " ?" with a space before for "?" without space. I am unable, I know I can find "~? " but them will show me all "?". Any one have a better way to replace it? Thanks in advance.

Hi, Can anyone please help me in replace the below values (in rows) with space. Actual it looks like : <colgroup><col width="200" style="width:150pt"> </colgroup><tbody> D[24954] Q1 D[24955] Q2 D[24956] Q3 D[24957] Q4...

I have a column that contains CSV. For example, 1,2,3,4,5 2,4,1,3,5 4,1,2,3,5 The order of these numbers is important as it records a sequence. Unfortunately, my data includes a bunch of shorthand. The above data is recorded in my data as follows: 1-5 2,4,1,3,5 4,1-3,5 How do I write a...

I relatively new to VBA so not exactly sure of the best way to achive this: I am trying to anonymise a column of data. I need to replace all letters in the cell with an * apart from the first letter. I have tried this: Sub AnonymiseCAR() Dim CounterCAR Dim ClientName As String 'Select CAR...

Hello friends, I created a macro to replace some characters. It worked for a while an today, when i tried to run it again, nothing happens! If I got through f8 process it "sees that "p" is >0 but the "Then Mid(temp, i, 1) = Mid(codiB, p, 1)" does not replace anything. Does anybody knows whats...

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".

Hi All, I have a macro that replaces a token in a string of text with the content of a cell. 99% of the time this works perfectly and the tokens are replaced. Occasionally, excel decides it's going to replace every occurance of the token in the whole sheet! I've run this hundreds of times...

Hi, I have this value on my cell, say A1: <>Max Power @ 2 OHM: 1000w x 2 <>RMS Power @ 4 OHM: 300w x 2 <>Max Bridged Power @ 4 OHM: 2000w x 1 <>Signal-to-noise ratio: 102 dB <>THD: 0.01% <>Dimensions: 11 7/8� W x 2 5/8"" H x 16 13/16� L <>Trimode operation <>Bridgeable <>Remote subwoofer...