Home/ Questions/Q 5050
Next
In Process
Computing Staff
  • 16
Asked: 2021-11-12T09:49:20+00:00 In:

Excel – Copying Part Of A Cell To A New Cell

  • 16

What excel formula would I use to copy just the number after “CallID=” which in Cell A1 is 172155416 over to Cell B1?

zttp://www.abcdefghijklm.com/webreports/audio.jsp?callID=172155416&mailboxID;=280332&authentication;=B4B15093

Thanks Totrio

Share

    1 Answer

    1. It depends.

      The main function you need is the MID function which has this syntax:

      MID(text, start_num, num_chars)

      If every cell has the same numbers of characters before the string you want to extract (in this case 58) and the string is always the same number of characters (in this case 9), then a basic MID function can be used:

      =MID(A1,58,9)

      If some cells might have a different number of characters before the string you want to extract but the string is always the same number of characters (in this case 9), then a FIND function can be added to find the “equal sign” and use that as the start_num argument for the MID function:

      =MID(A1,FIND(“=”,A1)+1,9)

      If some cells might have a different number of characters before the string you want to extract and the string might have a varying numbers of characters also, then a couple of more FIND functions can be added to determine the number of characters between the “equal sign” and the “ampersand” and use that as num_chars argument for the MID function:

      =MID(A1,FIND(“=”,A1)+1,FIND(“&”,A1)-FIND(“=”,A1)-1)

      If there is nothing consistent for the formula to find, such as an equal sign before the string and an ampersand afterwards, then things get considerably more difficult and we’ll need some more examples.

      Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

      message edited by DerbyDad03

      • 0