4
votes
1answer
124 views

ms excel find and replace @ symbol results in broken formula

I'm trying to search and replace in excel, the column is formatted as 'Text'. Find: [@ replace with: @ Whenever this finds a match at the start of a cell i.e the cell contents start with [@ and ...
1
vote
2answers
997 views

How can I find and replace multiple values within selected cells?

I want to run a find and replace on multiple values within a range in excel with values from 2 columns: A with the original string; B with the replacement string. I already found a macro that is ...
0
votes
1answer
801 views

Find and replace a word in one Excel file accross multiple sheets

How do I find and replace a word in one Excel file across multiple worksheets in the same file?
0
votes
2answers
410 views

Find and replace slashes with new linfeed in Excel 2010

Can anyone tell me how to replace a slash (/) with a linefeed in Excel 2010? I have a very long worksheet with words, origins, and definitions. In the origins column, some rows show multiple places ...
0
votes
1answer
422 views

Replacing a certain string after a certain character in Excel

I'm organizing my Mame files in a way that all the games marked with mature (meaning adult content) are filtered out. I have a text file in Excel (one game per line) and I'd like to accomplish the ...
3
votes
4answers
2k views

Excel Smart Find and Replace only specific characters

I want to change INT to INTERNATIONAL and NA to NATIONAL ASSEMBLY in whole excel workbook through an excel Macro or Find and Replace dialogue box. But when I run the macro or change it through Find ...
0
votes
2answers
2k views

Excel - find and replace images?

I exported a huge page from confluence into excel and it has a few columns that contain images. I need to convert them into text before I do another transition but this would be totally killing to do ...
8
votes
2answers
7k views

How to find and replace the character “*” in excel

I am trying to find and replace the * (star, or shift+8) character in a bunch of formulas in Excel 2007. * of course matches the ENTIRE contents of the cell, which is not what I want. How do I ...
1
vote
1answer
2k views

Excel - replace multiple strings in a single cell, based upon a lookup table

I would like to do a replace on multiple strings within a cell, based upon a lookup table. My lookup table has two columns: AUSTRIA | AT BRAZIL | BR COLOMBIA| CO My data table has two columns: ...
2
votes
4answers
978 views

Extracting text from a cell in Excel

I have a long list of items in Column A that includes a code and descriptive text. I need to separate the code from the text description. <ABC,1122, A1> - This is the text description The ...
2
votes
2answers
4k views

How to search & replace within a cell value?

I have a cell A and its value is 122abb12. In another cell B, I want its value to be the value in cell B but all 1 should be replaced by I - value in cell B should be I22abbI2. What is the function ...