| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing specific data from fields
If you have data rows with 102 characters and from position 1 to 13
was unit number, 14 to 25 was description, 26 to 32 was price etc, how would you pull the price out of the field and place it in it's own column with the correct format (inserting a comma at the correct place eg. 12,95) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
removing specific data from fields
Hi Splat
Something like: =--MID(A1,26,7) and format the formula cell with the correct format (via FormatCellsNumber tab). The Mid extracts 7 characters from starting position 26. The double minus converts the string to a numeric value. Hope this helps! Richard On 29 Jan, 06:59, "splat" wrote: If you have data rows with 102 characters and from position 1 to 13 was unit number, 14 to 25 was description, 26 to 32 was price etc, how would you pull the price out of the field and place it in it's own column with the correct format (inserting a comma at the correct place eg. 12,95) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
removing specific data from fields
Thanks Richard!
On Jan 29, 10:53 am, "RichardSchollar" wrote: Hi Splat Something like: =--MID(A1,26,7) and format the formula cell with the correct format (via FormatCellsNumber tab). The Mid extracts 7 characters from starting position 26. The double minus converts the string to a numeric value. Hope this helps! Richard On 29 Jan, 06:59, "splat" wrote: If you have data rows with 102 characters and from position 1 to 13 was unit number, 14 to 25 was description, 26 to 32 was price etc, how would you pull the price out of the field and place it in it's own column with the correct format (inserting a comma at the correct place eg. 12,95)- Hide quoted text -- Show quoted text - |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
removing specific data from fields
Belated reply (especially since I am reading this offline) as you
already have a working solution, but this would seem to be the perfect situation for data/text to columns and then use fixed width to seperate the fields. -- Kevin Vaughn www.klvaughn.com "splat" wrote in message ups.com... Thanks Richard! On Jan 29, 10:53 am, "RichardSchollar" wrote: Hi Splat Something like: =--MID(A1,26,7) and format the formula cell with the correct format (via FormatCellsNumber tab). The Mid extracts 7 characters from starting position 26. The double minus converts the string to a numeric value. Hope this helps! Richard On 29 Jan, 06:59, "splat" wrote: If you have data rows with 102 characters and from position 1 to 13 was unit number, 14 to 25 was description, 26 to 32 was price etc, how would you pull the price out of the field and place it in it's own column with the correct format (inserting a comma at the correct place eg. 12,95)- Hide quoted text -- Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Removing specific data from a bar chart | Charts and Charting in Excel | |||
Linear Mode
