Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing linked file - can still be referenced but can't find it! | Excel Worksheet Functions | |||
Find and search by column | Excel Discussion (Misc queries) | |||
EDIT FORMULA BAR in excel 2003? why not? where is it? | Excel Worksheet Functions | |||
Edit + Find | Excel Discussion (Misc queries) | |||
How to sort/update large excel db | Excel Discussion (Misc queries) |