I am using Excel 2007 and I want to create a formula that says – if A2 contains a number xxxxxx, I want Excel to enter a name into cell C2.
This is because I’ve been given a workbook that contains various sheets and a column for the name hasn’t been included, so I want to insert it but not have to go through every line inserting the name – with the potential for making a mistake !
I do hope this can be done as I will want to use it each month until the spreadsheets comes in with the name column already completed.
Regards,
Julia
