troubleshooting Question

excel - parsing out information in rows

Avatar of jamesmetcalf74
jamesmetcalf74Flag for United States of America asked on
Microsoft OfficeMicrosoft ExcelMicrosoft ApplicationsVBA
5 Comments4 Solutions109 ViewsLast Modified:
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)
ASKER CERTIFIED SOLUTION
Wayne Taylor (webtubbs)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 4 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros