Split PN and Price
 

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

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.

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.