I am trying to extract the manes from a large string and place them into column B from column D. the problem i am having as the only unique identifier to pick from @ comes after the name and as such i can't seem to extract the name SmithJ*** the strings i have are around 700 chars and therefore lots of the <> are repeated
Here is a sample. the 2 identifiers are in bold. Each string may be slightly different but they will all contain the @ symbol after the name and the > before the name. then i would like to place those names into column B
I am happy for either VBA or a formula.
Here is a sample. the 2 identifiers are in bold. Each string may be slightly different but they will all contain the @ symbol after the name and the > before the name. then i would like to place those names into column B
I am happy for either VBA or a formula.
wdwhnkljnwef<>fgf4rtsdgsger<>qwdqwefwrf<+=xxvcdsvwdfgerg,>wdfwerf"dfgbfhrgh"vbbg>vbedgfg)"true">SmithJ120@me.comfwfihfrf>,mdgegergerg< Value=<>edfegTest"fggnfgn" |