Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ayden Smith   on Feb 20 In MS Office Category.

trouble with IF/OR, Left and a simple loop


  
Question Answered By: Marnia Mian   on Feb 20

Acct# is a separate column but I just realized that because the data
is normally exported as text by a custom accounting application it may
start with non-numeric characters, including spaces, in which case (I
noticed) the FindNumericPart Sub does not work (Ex. data is "acct
411.Domestic Customers" - in which case I need to extract 411). Can
you provide a fix?

Share: 

 

This Question has 20 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on trouble with IF/OR, Left and a simple loop Or get search suggestion and latest updates.


Tagged: