I need to extract middle name from full name.
for some case its working but in those names without middle name, it throws #VALUE! error.
also while copying the only extracted middle name, it shows the formula instead of the name.
Can someone help me on this please..!!
How can we do this?
How value error can be removed?