Split PN and Price

[Guest]

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

TIA.

Andri

 

[JE McGimpsey]

One way:

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

 

[Guest]

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"

One way:

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

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.