• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel problem

Thanks all for the help. Job done and newsletter (spam :tongue), on the way.
 
Bit late but this formula would have helped:

Code:
=IF(LEN(A1)-IFERROR(FIND(".co.uk",A1),0)=5, ".co.uk","")
 
real men use AWK!
 

Advertisers

Back
Top