Posts by mrmmickle1

    Re: Position Chart in Range

    You can also size a chart to a specific Cell that you have previously sized:

    Re: Copy info from other workbook from cell

    Try this:

    =CONCATENATE(VLOOKUP(A1,'C:\Users\Folder\[employees.xlsx]Sheet1'!A:D,2,FALSE)&" ",VLOOKUP(A1,'C:\Users\Folder\[employees.xlsx]Sheet1'Sheet1!A:D,3,FALSE))

    You can put that in a hidden column then you can have two formulas in column 3 or 4 that will extract the first and last name

    something like this =LEFT(A1,FIND(" ",A1)-1)

    and this =MID(A1,FIND(" ",A1)+1, 99)