AboutRichard Roberts Expertise Can assist you in most areas of Excel, have been working with it for about 15 years in many types of applications, but primarily in financial and accounting applications. I am a CPA and many client or client problems have necessitated the use of excel. I am not an expert in charting, macros, or pivot tables.
Experience Have been working with Excel for about 15 years primarily in accounting and financial areas.
Question Hi Richard...
Say I need only numeric potion of a thousand of alpha numeric string by formula...how cud I get it...
example...
Lod awb #58505010185.
being Rod sales recd agsnt 58505010045
being cod collection recd agsnt 58502923264
58503408434 GOD CASH SALES ANANYA RAY
being amt coll Agnst AWB No.58503409882
Here I need only numeric part...pls help...
Answer Arindam
One way to get you desired result is --if the numbers are consistently in the same place in the string, use text to columns, fixed width and split the string at that point. If there is a common delimiter before the number use text to columns and split the string at that delimiter.
For example if all numbers begin at the 5th place in the string then split the string at that point using fixed width.
If all numbers begin after the # sign then use that delimiter to split the string.
You can also use the LEN formulas to remove unwanted text or numbers, for example.
=RIGHT(D12, LEN(D12)-5)
The above formula will remove the first 5 integers or text from the start of the string to the 5th integer or text, so if the cell D12 contains aolp#3427684 the formula will convert this to
3427684. Check the help section for more information on the LEN formulas.
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
