jkl

<tbody> ABC - DEF - GHI - JKL - MNO ABC DEF GHI JKL MNO ABC - DEF - GHI - JKL - MNO ABC DEF </tbody> Using SPLIT with a "-" delimiter gives the first output above - is there a way to limit the command so it splits ONLY the first two parts? Thanks for your help!

I am trying to create a task list of pending tests on 1 main worksheet from another worksheet with multiple account numbers for the same person. I need to match the account number (which is repeated multiple times on the worksheet I am pulling from) to a column that may or may not have a date...

Hi I'm looking to achieve the following ! I don't know whether to use vlookup, offset, indirect or a combination of 2 have looked and looked and looked !! and can't find a solution similar to what I'm trying to achieve I did see one post similar but it didn't solve it for me :( ok here's what...

Hi Team, I have a bunch of data in a table that I need into a column set up as per the below. Base Data <tbody> QWE ASD ZXC RTY ABC 10 20 30 DEF 40 50 GHI 60 70 80 JKL 90 100 </tbody> Formatted Data <tbody> Head 1 Head 2 Head 3 ABC 10 QWE ABC 20 ZXC ABC 30 RTY DEF...