Formula to delete text

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:38 PM GMT


In a colum I have verbage after an(*) that I want deleted, the information is in column J all the way down. Can you give me a formula to dlete it.



I am not sure what you want in way of a formula, but, a procedure to accomplish the replacement would be to

select the column On the Home tab, find and select (way to the right) then Replace

The tricky part is that to replace everything after an asterisk you need to replace



The ~ before the first asterisk means that the asterisk is really to mean and asterisk, not a wild character. Second * is the wild card. For the replacement input, the ~ is not necessary; an * will be plugged in; leaving the cell contents the same except for every thing after the * being gone.


©2024 eLuminary LLC. All rights reserved.