Search:

Type: Posts; User: rfallen; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    452

    Your Excel format is far from being in a...

    Your Excel format is far from being in a normalized state to make it possible to import to Access.

    If all the information in your spreadsheet is replicated in the 3rd party DD application, could...
  2. Replies
    7
    Views
    686

    You can check for cells having spaces as well as...

    You can check for cells having spaces as well as empty with this formula:

    =IF((CONCATENATE(TRIM(A3),TRIM(B3),TRIM(C3))=""),"N/A",CONCATENATE(A3,B3,C3))

    Regards, Rick
Results 1 to 2 of 2