Maybe you could just do a mass change:
select the range to fix
edit|replace
what: ~*
with: (leave blank)
replace all
Since the asterisk represents a wild card, you need that tilde to tell excel
that you really want the asterisk character--not the wild card.
cencoit wrote:
I am importing information from our accounting program. one of the
columns has text containing product name and after several of the
product names there is a *. This is used by the accounting program to
designate differential pricing. Is there a way to sort for the text
containing the * so I can delete from the text. an example would be as
follows
dekalb 1543t*
Thanks
--
cencoit
------------------------------------------------------------------------
cencoit's Profile: http://www.excelforum.com/member.php...o&userid=27378
View this thread: http://www.excelforum.com/showthread...hreadid=471370
--
Dave Peterson