Link to home
Start Free TrialLog in
Avatar of Jim Metcalf
Jim MetcalfFlag for United States of America

asked on

excel - parsing out information in rows

i have about 1000 rows that have log information.

here is an example of one of the rows
"<Bill generation for>: Account 0278069001 not billed – No unbilled meter readings were found for service WW IR"


I am interested in the accountnumber information in the row that is ten digits.   I need to extract that out of the rows and put it in a separate column beside the cell.
example.  
"<Bill generation for>: Account 0278069001 not billed – No unbilled meter readings were found for service WW IR"

would have in cell a1
 "<Bill generation for>: Account 0278069001 not billed – No unbilled meter readings were found for service WW IR"
and in a2 it would have   (this needs to be extracted out of a1)
 "0278069001"


the account numbers vary in positional placement in the row.  can't use text to data or fixed with.
I need a formula that parses the content of the cell (a1) for a number of 10 digits in length and places it (a2)
SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The chosen answers resolved the question. :)