View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

One way:

Data/Text to Columns/Delimited/Other [$]

In article ,
"Andri" wrote:

Need your help i have a text looks like this:
10-44 $ 1,018.00 90
107-337 $ 266.35 90

the left portion is the part number and after dollar is the price.

Which function to be used in order to split the text. while the PN is
different digit.