View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_2_] Gary Keramidas[_2_] is offline
external usenet poster
 
Posts: 364
Default Clean/replace textstring

see if this formula will work for you
=SUBSTITUTE(A1,"*","")

--


Gary


"CG Rosén" wrote in message
...
Good Day Group,

My textstring looks like this; ****abcdef**.
The important message is the letters, the asterics are
remains of "wildcards". Is there a simple way to clean
the string to only show the letters? The length of the
letters are variable as well as the numbers of *.

Any help valueable. Thanks.

Brgds

CG Rosén