Split PN and Price

A

Andri

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
 
X

xlbo

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 said:
One way:

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

Andri said:
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.
Click to expand...
Click to expand...
 
Top