Please help! This is probably easy for you guys, not me!
I have a spreadsheet with National Insurance Numbers in one column, and I need the format code for 'custom' when you go into format cells to remove the last digit automatically. for example, if the NI Number was AB123456C, I need the formula to automatically remove the 'C'
thank you! :thanx: