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.
|