Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro's for figuring Price Lists?!? | Excel Discussion (Misc queries) | |||
Populate cells with a unit price | Excel Discussion (Misc queries) | |||
Product Price List with 14k records, filter w/out using AutoFilter | Excel Worksheet Functions | |||
Computing Sales Tax and Retail Price from a number | Excel Worksheet Functions | |||
Calculating Net Position and Average Price | Excel Worksheet Functions |