Forum Discussion
Find & Replace Issues
The find and replace function is telling me it can't anything to replace. Why can it not find the data that is there?
Ok so I don't think "dirty" hehe data is the cause. the information in the cells was generated by Qualtrics a survey program our university provides. so the information was exported to excel and I used the expanded options in Find and Replace to identify the exact format I was seeking to change and edited one entry to use it as the other format I wanted to change it to, but it still says it can't find the information. I'm basically trying to change Junior BB to Jr. BB and I'm struggling.
Hi sgravois,
"information in the cells was generated by Qualtrics" I had a hunch and I was on the right track.
OK try using the SUBSTITUTE() and/or REPLACE() functions and see if that helps.
"information in the cells was generated by Qualtrics" I had a hunch and I was on the right track.
OK try using the SUBSTITUTE() and/or REPLACE() functions and see if that helps.
- Ok I tried to use both functions, but I'm completely outside of my wheelhouse and it isn't working for me. It's a little bit more complicated than expected. The data has about 10 different options in the column I'm trying to just shorted the verbiage. Why won't find and replace work for me? Why is a formula a better route than using the function that has worked for me in the past?
- Could you pls upload the file with few entries to check.
