Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
EXTRACTING NUMBERS FROM A TEXT CELL
Hello!
Currently I am unable to download information from the accounting system in a better format. So one line of information come into Excel in one cell, hence, the example below: @1 0325@1 OPENING BALANCE : .....ESTIMATED COST - MATERIAL@1< 813,936.29 There are two things I need to learn he 1) How can I extract just the number. 1a) I tried the using the formula: =RIGHT(A1, 11) and i was able to extract the number, however, i faced two problems. 1c) The 1st problem was that the extracted number came out as a text and I was unable to do any mathematical operation on it, such as, addtion. 1b) The 2nd problem was that I had to change the 'num chars' in the formula as the numbers are on varoius lengths. 2) How can I parse the data once in Excel, if I want to do that. Thanks in advance SJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easiest way to remove text from a cell that has text and numbers? | Excel Discussion (Misc queries) | |||
text and numbers in cell | Excel Worksheet Functions | |||
How can I remove diff. numbers from a cell combined with text | Excel Discussion (Misc queries) | |||
Change CSV-load cell format from GENERAL to TEXT for numbers? | Excel Discussion (Misc queries) | |||
Making calendar with numbers and text in same cell | Excel Discussion (Misc queries) |