Find and edit column entries

[cencoit]

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

[Dave Peterson]

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

[cencoit]

Thanks that worked great