You're welcome...........thanks for the feedback..........

Merry Christmas to you and yours as well..........

Vaya con Dios,
Chuck, CABGx3



"inthestands" wrote:

Thanks, this worked great. Have a Happy Holidays to you and yours
--
inthestands


"CLR" wrote:

=LEFT(A1,FIND("*",A1,1)-1)&" "&MID(A1,FIND("*",A1,1)+1,99)

Vaya con Dios,
Chuck, CABGx3



"inthestands" wrote:

We have a number of items that we have in our inventory that are overstocked.
We want to highlight them by removing the spaces and replacing them
asteriks. Now we want to replace the first * that is in that description
with a space instead.The first asterik may appear as the 3rd charactor or up
to the 12th charactor in the product description.
Is there a formula there that I can use. as an example;

Bubble*Gum*Grape*Flavor*****12*pack (as it is now)
Bubble Gum*Grape*Flavor*****12*pack (the way I would like it to read)
--
Thanks in advance,
inthestands