Consulting

Results 1 to 4 of 4

Thread: Solved: formulas help.

  1. #1
    VBAX Contributor
    Joined
    Jun 2008
    Posts
    169
    Location

    Solved: formulas help.

    Hi, experts

    Don’t know does it work or not for my questions, but wanna try if someone help/asked way to do.
    Looking for a formulas to split out the address which is many difficultly what I doing now………
    as I knowing it the formula can do but just one logic… how do change for multiple logic ? if ok that’s greatful for me.

    =MID(A1,1,FIND({"AVE"},A1)-2) ( can someone help how do change multiple creteria )

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    Hi KK1996,

    You can't expect much help when we can't see the data. Besides, how would you propose to handle the address for someone who's address is:
    1st Floor, St Andrews St, St Albans Sth
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Try this

    =MID(A2,1,MIN(IF(ISNUMBER(SEARCH({"Ave","Road"},A2)),SEARCH({"Ave","Road"}, A2)))-2)

    array-entered
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  4. #4
    VBAX Contributor
    Joined
    Jun 2008
    Posts
    169
    Location

    Thumbs up

    Quote Originally Posted by xld
    Try this

    =MID(A2,1,MIN(IF(ISNUMBER(SEARCH({"Ave","Road"},A2)),SEARCH({"Ave","Road"}, A2)))-2)

    array-entered
    hI, xLD

    The formulas work pefect for me . thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •