Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace first * with a space in a description
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace first * with a space in a description
=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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace first * with a space in a description
Chuck, I've always been curious......
What is CABGx3? Biff "CLR" wrote in message ... =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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace first * with a space in a description
=SUBSTITUTE(A1,"*"," ",1)
"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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace first * with a space in a description
http://www.medicinenet.com/coronary_...ft/article.htm
(times 3) "T. Valko" wrote: Chuck, I've always been curious...... What is CABGx3? Biff "CLR" wrote in message ... =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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace first * with a space in a description
Abbrevaition for Coronary Artery Bypass Graft, times 3.......in other words,
a Triple Heart Bypass..............survivor. Definately NOT a fun-thing, but better than the alternative<G. Vaya con Dios, Chuck, CABGx3 "T. Valko" wrote: Chuck, I've always been curious...... What is CABGx3? Biff "CLR" wrote in message ... =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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace first * with a space in a description
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace first * with a space in a description
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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace first * with a space in a description
Very good Dave.......are you a "Zipper Club" member? Usually the only ones
who know what that means are the Med Students and the ones who have "been there". Vaya con Dios, Chuck, CABGx3 "Dave Peterson" wrote: http://www.medicinenet.com/coronary_...ft/article.htm (times 3) "T. Valko" wrote: Chuck, I've always been curious...... What is CABGx3? Biff "CLR" wrote in message ... =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 -- Dave Peterson |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace first * with a space in a description
Definately NOT a fun-thing, but better than the alternative<G.
I hear ya! Hang in there! Biff "CLR" wrote in message ... Abbrevaition for Coronary Artery Bypass Graft, times 3.......in other words, a Triple Heart Bypass..............survivor. Definately NOT a fun-thing, but better than the alternative<G. Vaya con Dios, Chuck, CABGx3 "T. Valko" wrote: Chuck, I've always been curious...... What is CABGx3? Biff "CLR" wrote in message ... =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 |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace first * with a space in a description
I used to work with a couple of young guys (in their 40's when they had their
surgeries) that used to talk about cabbage stuff. Both are still doing well after 5-10 years. CLR wrote: Very good Dave.......are you a "Zipper Club" member? Usually the only ones who know what that means are the Med Students and the ones who have "been there". Vaya con Dios, Chuck, CABGx3 "Dave Peterson" wrote: http://www.medicinenet.com/coronary_...ft/article.htm (times 3) "T. Valko" wrote: Chuck, I've always been curious...... What is CABGx3? Biff "CLR" wrote in message ... =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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clean non printable characters and replace with space | Excel Worksheet Functions | |||
replace multiple entries in excel state=st west=w east=e conti | Excel Worksheet Functions | |||
replace multiple entries in excel state=st west=w east=e conti | Excel Worksheet Functions | |||
replace multiple entries in excel state=st west=w east=e continue | Excel Worksheet Functions | |||
formula that will go up one space if no value in specified space | Excel Worksheet Functions |