Log In
Register
Home
July 21, 2020
Offline
Hi
I have a problem in creating dependent lists with validation, and in my filter, I have the Data Validation entry with space, or with "&", or with "-" , I used =INDIRECT(SUBSTITUTE(J9," ","_"), it works for the entry with space, but it didn't work for "&" and "-".
what I should do then?
thanks,
Yvonne 
July 16, 2010
Offline
Hi Yvonne,
Welcome to our forum! Please attach a sample Excel file so we can see the whole picture of your formula and how it relates to the worksheet. Anonymise it if required.
Mynda
July 21, 2020
Offline
Hi Mynda,
Nice to e-meet you! Here is the workbook I refer to.
October 5, 2010
Offline
Hi Yvonne,
No attachment. There's a video here showing how to attach files
https://www.myonlinetraininghu.....this-first
Regards
Phil
July 21, 2020
Offline
HI
Try it again.
VIP
Trusted Members
December 7, 2016
Offline
Hello,
In order to substitute several characters you need to nest the SUBSTITUTE function per character/word you want to change. You can read more about it in this blog post.
Example: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C9,"&","_"),"-","_")," ","_")
Br,
Anders
1 Guest(s)
