I have attached a worksheet example to demonstrate my problem.
EXCEL HELP.xlsx
COLUMN A contains data copied in of which some will be joined numbers, like in A1, some blanks (A2), some simple numbers (A3).
Sean Thomas has been an awesome help in showing me how to join and split the numbers up (B1 & C1).
But the problem I'm having is working out a suitable IF argument for B2:C3 so that when number imported is joined like A1, it splits them to B and C, if it's blank like A2 then B & C remain blank, or if its simple like A3 then copies to B3, but leaves C3 blank.
Hope this makes sense!!
TIA!
Bookmarks