Find and edit column entries
 

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

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

Thanks that worked great


--
cencoit
------------------------------------------------------------------------
cencoit's Profile: http://www.excelforum.com/member.php...o&userid=27378
View this thread: http://www.excelforum.com/showthread...hreadid=471370