View Single Post
  #1   Report Post  
MosesX8
 
Posts: n/a
Default How do I replace a character with another?

In my spreadsheet I have the cells in column F referencing from cells in
column C. The original content in the cells in column C have spaces in them.
What I want to happen is have the cells in column E have all spaces ( )
replaced by periods (.). I know I can go to EditReplace, but the cells are
often updated and would be much easier if I didn't have to replace them every
time.

In cell C3:
A Stupid Example

In cell F3:
A.Stupid.Example

Thanks!