Hi all,
Does anyone know if it's possible to take a big range of data and replace
all capital letters with lowercase ones, except if they're directly in front
of a symbol? As an example,

Example would turn into example
EXAMPLE would turn into example
#Example would stay #Example
#EXAMPLE would turn into #Example

I'm macro challenged, so I have no idea how to write or use macros. If
there's a formula for this, please tell me, but if there's a macro can you
please tell me what it is and how to set it up so it works?

Thank you so much!