🌐
Super User
superuser.com › questions › 1202665 › case-insensitive-but-case-preserving-substitute-function-excel
Case insensitive but case preserving substitute function, excel - Super User
=SUBSTITUTE(A1,"foo","bar") is case sensitive, SUBSTITUTE(lower(A1),"foo", "bar") is good for some applications, but removes any existing case distinctions from A1; so FoofooFOO would go to barbarbar.
🌐
wmfexcel
wmfexcel.com › 2016 › 07 › 16 › case-insensitive-substitute
Case-insensitive SUBSTITUTE???… | wmfexcel
July 17, 2016 - Use the case-insensitive SEARCH function to locate the position, and REPLACE to update the text, with an IFERROR to handle no match. =IFERROR(REPLACE(A2,SEARCH(“input”,A2),5,”output”),A2) The 5 reflects the length of the find-text ...
Discussions

How to make this formula not case sensitive
SEARCH is the case-insensitive version of FIND More on reddit.com
🌐 r/excel
6
2
May 6, 2019
Difference between Substitute and Replace Function
SEARCH is case insensitive. ... REPLACE allows you to replace a substring with a another of different length too. To change "brown fox" to "brown bear" ... Please Login or Register to reply to this topic. ... Currently viewing this topic 1 guest. ... More results... ... Sign up to our newsletter and join over 400,000 others who learn Excel ... More on myonlinetraininghub.com
🌐 myonlinetraininghub.com
2
August 7, 2018
excel - Replace part of text in a cell case sensitive - Stack Overflow
This seems easy but I couldn't find an answer. Each solution either replaced part of the cell, or replaced case sensitive but then the replace text had to equal the value in the cell If InStr(1, More on stackoverflow.com
🌐 stackoverflow.com
How to use Excel VBA replace function with case sensitivity? - Stack Overflow
This code should replace the words with the case typed by the user, instead it always replaces with the first searc ignoring the case. Any ideas on how to fix it? Sub chaser() Range(Range("B15"), More on stackoverflow.com
🌐 stackoverflow.com
🌐
ExcelFind
excelfind.com › excel-functions › excel-substitute-function
How to use the Excel SUBSTITUTE function - ExcelFind.com
February 12, 2024 - The Excel SUBSTITUTE function replaces text in a given string by matching. It’s used to replace specific text in a string with another text. SUBSTITUTE is case-sensitive and provides precise control over replacements.
🌐
Reddit
reddit.com › r/excel › how to make this formula not case sensitive
r/excel on Reddit: How to make this formula not case sensitive
May 6, 2019 -

I have this.

=IF(COUNTIF($A2,"* *"),CONCATENATE(MID((IF(ISERR(FIND(" ",$A2)),"",LEFT($A2,FIND(" ",$A2)-1))),1,(30-LEN($T2))/2)&MID(TRIM(RIGHT(SUBSTITUTE($A2," ",REPT(" ",100)),100)),1,(30-LEN($T2))/2)),CONCATENATE(LEFT($A2,(30-LEN($T2)))))

Basically it looks for spaces IF(COUNTIF($A2,"* *")

if there is no spaces it just takes from cell CONCATENATE(LEFT($A2,(30-LEN($T2)))))

If there are spaces CONCATENATE(MID((IF(ISERR(FIND(" ",$A2)),"",LEFT($A2,FIND(" ",$A2)-1))),1,(30-LEN($T2))/2)&MID(TRIM(RIGHT(SUBSTITUTE($A2," ",REPT(" ",100)),100)),1,(30-LEN($T2))/2))

This takes from the first word MID((IF(ISERR(FIND(" ",$A2)),"",LEFT($A2,FIND(" ",$A2)-1))),1,(30-LEN($T2))/2)

This takes from the last word MID(TRIM(RIGHT(SUBSTITUTE($A2," ",REPT(" ",100)),100)),1,(30-LEN($T2))/2))

I put it into action today and realized that if it has a space it dose not work if the words in the cell are all Capital Letters.

Any suggestions to make it work for Capitals

🌐
Excel Forum
excelforum.com › excel-general › 843716-how-do-i-make-this-formula-not-case-sensitive.html
How do i make this formula not case sensitive? [SOLVED]
Excel 2011 · Posts · 10 · so im using this formula to return a value based on the letter U in a cell: =SUM(LEN(BO5:BO14)-LEN(SUBSTITUTE(BO5:BO14;"U";""))) but how do i make it not case sensitive, as it stands now, it only registers capitals, and its the other way around, if i make the u small in the formula, can you come around this?
🌐
Microsoft Power Platform Community
powerusers.microsoft.com › t5 › Building-Power-Apps › Substitute-Case-Insensitive › td-p › 1437891
Forums | Microsoft Power Platform Community
Their mission is to reduce income inequality by equipping individuals with skills in Dynamics 365 and Power Platform, and connecting them to job opportunities. Through comprehensive programs and the support of dedicated mentors, TechFluent aims to inspire and prepare the next generation of tech innovators, fostering a culture of inclusion and excellence in the industry.
🌐
My Online Training Hub
myonlinetraininghub.com › excel-forum › excel › difference-between-substitute-and-replace-function
Difference between Substitute and Replace Function • General Excel Questions & Answers • Excel Forum
August 7, 2018 - SEARCH is case insensitive. ... REPLACE allows you to replace a substring with a another of different length too. To change "brown fox" to "brown bear" ... Please Login or Register to reply to this topic. ... Currently viewing this topic 1 guest. ... More results...
🌐
LiveFlow
liveflow.com › product-guides › substitute-function-in-excel-explained
SUBSTITUTE Function in Excel: Explained | LiveFlow
It's important to note that the SUBSTITUTE function in Excel is case-sensitive when finding the text or characters to replace. This means it will only replace text or characters that match the case of the specified old_text.
Find elsewhere
🌐
Ozgrid
forum.ozgrid.com › ozgrid free excel/vba help forum › help forums › excel general
Substitute Function Non-case Sensitive - Excel General - OzGrid Free Excel/VBA Help Forum
Hi, is it possible to make a SUBSTITUTE finction non-case sensitive? For example I want to replace all letters "e" and "E" in a cell. Thanks for answers
🌐
Spreadsheet Planet
spreadsheetplanet.com › home › excel functions › substitute function in excel
SUBSTITUTE Function in Excel (5 Easy Examples)
June 4, 2026 - SUBSTITUTE is case-sensitive. It treats “a” and “A” as different text, so “Apple” won’t be matched if you search for “apple”. Wrap the text in UPPER or LOWER first if you need a case-insensitive match.
🌐
MyExcelOnline
myexcelonline.com › home › how to use vba replace function in excel – a guide to text manipulation with 4 examples
How to Use VBA REPLACE Function in Excel - A Guide to Text Manipulation with 4 Examples | MyExcelOnline
March 30, 2024 - In cell A5, every instance of ‘v4.0’ has been successfully substituted with ‘v5.0’. VBA Replace is a case-sensitive function but you can use the optional argument “compare” to make it work in a case-insensitive manner.
🌐
ExcelBaby
excelbaby.com › home › functions › excel formulas and functions › substitute function
SUBSTITUTE function - ExcelBaby
December 12, 2022 - If you need to count how many times a specific character appears in a cell, you can do so with a formula that uses SUBSTITUTE and LEN. SUBSTITUTE is a case sensitive function, so it will match case when running a substitution.
🌐
FMForums
fmforums.com › home › brain food › the left brain › case insensitive substitute possible?
Case INsensitive substitute possible? - The Left Brain - FMForums.com
January 7, 2021 - Anyone have a suggestion on how to compensate for the substitute function being case sensitive? I'm trying to create a simple text highlighting feature in a database. I don't want to alter the original source text field so I'm creating a calculated field that references the original field with a ...
🌐
ExcelTrick
exceltrick.com › home › excel substitute function – how to use
Excel SUBSTITUTE Function – How to Use
November 8, 2023 - Next, we will try our hand at some ... categorized as a String/Text function in Excel. The SUBSTITUTE function is case-sensitive and does not support wildcard characters....
🌐
Auburn University
eng.auburn.edu › ~tplacek › courses › 3600 › Strings and Manipulations.htm
Strings and Manipulations
SUBSTITUTE Worksheet Function is case sensitive to make an insensitive comparison both the from and the target must match in case, by using UPPER on the the target, and by using uppercase character within quotes.
🌐
Exceljet
exceljet.net › home › functions › substitute function
Excel SUBSTITUTE function | Exceljet
January 23, 2026 - The Excel SUBSTITUTE function replaces text in a given string by matching. You can use SUBSTITUTE to replace or completely remove matched text. SUBSTITUTE is case-sensitive and does not support wildcards.
🌐
MyExcelOnline
myexcelonline.com › home › substitute function – replace characters in excel!
SUBSTITUTE Function - Replace Characters in Excel! | MyExcelOnline
March 22, 2024 - Note: The SUBSTITUTE function is case-sensitive. To make it case-insensitive, you might need to use other functions like LOWER or UPPER for consistent replacements.