To keep the data together, you would be able to use the following formulae
BUT you are showing "90" at the end of each line - is this how the data is
laid out in your sheet ?

=TRIM( LEFT( A1 , FIND( "$" , A1 ) ) )

=VALUE( TRIM( RIGHT( A1 , LEN( A1 ) - FIND( "$" , A1 ) ) ) )
--
Rgds, Geoff

"A crash reduces
Your expensive computer
To a simple stone"


"JE McGimpsey" wrote:

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.