Hi,
I tried recording this formula I am not able to record as system prompts me "Unable to Record"
How Do i write this formula in a code?
Arvind=IF(ISERROR(LEFT(Import!AK2,1)&" "&LEFT(RIGHT(Import!AK2,LEN(Import!AK2)-FIND(" ",Import!AK2,1)),FIND(" ",RIGHT(Import!AK2,LEN(Import!AK2)-FIND(" ",Import!AK2,1)),1))&"INT"),"",LEFT(Import!AK2,1)&" "&LEFT(RIGHT(Import!AK2,LEN(Import!AK2)-FIND(" ",Import!AK2,1)),FIND(" ",RIGHT(Import!AK2,LEN(Import!AK2)-FIND(" ",Import!AK2,1)),1))&" INT")
Bookmarks