Urgent Excel Question! Please Help!!!!!!!?

Question

let's say that there is list of around 1000 cells where each one
says something like "Agt: Aceddedo, A / 7102014"
and I want to extract only the number from this cell and post it
on a new cell with the number only, and don't want to do it manually. How do I do this? Please help this is urgent. thanks

Answer 1

Page 6 - http://itg.unl.edu/resources/documents/ExcelExpert.pdf

Parse Text Without Formulas:

Occasionally you’ll have data in a range of cells that you’d like split apart into separate worksheet columns. For instance, if you have first and last name data stored in a single column you may want to move the first name data into one column and the last name data into another. Or, you may want to split a range of dates into separate columns for month, day and year.

Rather than attacking the problem with complex parsing formulas using LEFT, MID and RIGHT, you can often use Excel’s "Text To Columns" feature.

1. First enter first and last name data in column A of a worksheet. (You may also use middle initials.)

2. Then, select the data and choose Data!Text To Columns from the menu bar.

3. Click Next on the first screen of the Convert Text To Columns Wizard.

4. Clear the check boxes in the Delimiters panel and select the Space check box. A delimiter is simply the character that identifies the end of one string and the beginning of another—in this case; names are separated by a space. If you were
splitting data like a date, you could enter a slash (/) in the Other text box, since it delimits the month, day and year parts of a date.

5. Now, click Next to move to the last screen of the wizard. In the Destination text box, enter the worksheet cell address that indicates where you want the split data placed (for this example, enter B1).

6. Click Finish to complete the conversion.

Answer 2

Write a VB macro that reads the cell as a string, then starting at the right of the string, make a loop to read each character, compare that to 0-9, and if it is a match then copy that to a new string.
Then keep going through the loop til it stops reading numbers, and then write that string to a new cell.
VB has all the features that you need to get that done, like string.length and the tools to write to a new cell, workbook, whatever.

Answer 3

If the numbers are the same length (7 characters) you can use =RIGHT(A1,7) in the cell you wish to obtain the number. If you copy and paste the formula into other cells the cell name (A1) will change automatically.

Answer 4

If there is always a "/ " (that's a slash followed by a space) right before the number and nowhere else in the cell, then you can use this formula:

=VALUE(RIGHT (A1, LEN(A1)- FIND("/ ",A1)))

This assumes the list is in column A.

Answer 5

Here is a custom VB function that will extract numbers from any text:
http://www.ozgrid.com/VBA/ExtractNum.htm

Answer 6

export it to a text file then import it as a comma delimited file.. this will seperate the two information fields.

Answer 7

You cannot enter information into that program...it is ONLY a viewer