• I have a very long list of names, where the word "and" often appears between the two names. For example, "John and Mary."

• I want to find every occurrence of the word "and" and replace it with " ^ " (Purpose is to use as delimiter for later splitting text to column, but that is another matter). In the example above, I would like the names to be shown as "John ^ Mary".

• My problem: I can't figure out how to get Excel to include spaces in the text that I am seeking find and replace. In other words, I want Excel to look for (space)and(space). I have typed it into find like this: " and " << (without the quote marks, but typing a space before and after the word "and").

• However, Excel ignores the spaces when it does the replacement, which messes up my list.

More info: Issue is, many of the names on my list contain the letters "and", and Excel is finding and replacing those text strings, even though they don't have a space before and after. Example: "John and Sandra" would be replaced with "John ^ S^ra" (instead of "John ^ Sandra). Or, "Andrew" would be replaced with "^rew"

If "find" in Excel also included the spaces you entered, then the problem would be solved, but Excel apparently can't find the spaces. (This is unlike Word, which definitely can find spaces.)

I have been searching for an solution for a long time, can anyone help?

Hi, I have a large data set of numbers which have spaces in between, and I want to remove the spaces and replace them with commas (effectively making me able to sum them up for instance). Which formula can I use?

Have to make a ton of links to a database and can do that as the links are mostly the same but need to use the document title to mass produce so I don’t have to go and input every link. Is there a command that could convert spaces in a cell to “%20”? Couldn’t find it in their website online sorry. Edit: my version is Microsoft Excel for Microsoft 365 MSO (Version 2208

I have TONS of headers that look like the following

owner2_address_1_city

There underscores instead of spaces make it hard to read quickly and make wrapping text useless. is there an easy way to change it to normal text i.e. below:

"owner 2 address 1 city"

Thanks in advance!