0

If string contain text with one single special character (separator),

How to ad a space after point before separator and trim any space after separator?

Exemple string:

  • .Dolo.rum ipsum primos@ ar.deo
  • J.ust. simple text@ h er.e
  • Another fr.e.e @. exe mpl e

Expect result:

  • . Dolo. rum ipsum primos@ar.deo
  • J. ust. simple text@her.e
  • Another fr. e. e @.exemple
Losai
  • 329
  • 2
  • 9
  • 1
    Check out substitute(). And trim(). Often one can find useful functions by looking through the list of functions and reading the explanations given. – Solar Mike Mar 12 '22 at 20:34

1 Answers1

2

Since an accepted answer can't be deleted hence sharing the solution as mentioned in the first comment,

=SUBSTITUTE(LEFT(A1,FIND("@",A1)),".",". ")&SUBSTITUTE(MID(A1,FIND("@",A1)+1,LEN(A1))," ","")
Mayukh Bhattacharya
  • 12,541
  • 5
  • 21
  • 32