Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clean/replace textstring
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND, CLEAN, REPLACE question | Excel Worksheet Functions | |||
Clean non printable characters and replace with space | Excel Worksheet Functions | |||
Find a character in a textstring | Excel Discussion (Misc queries) | |||
"cut" textstring | Excel Programming | |||
=clean(a1) | Excel Programming |