Middle name extraction

[Closed]
Report
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
Hi,
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?

1 reply

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
Hi Tulika,

When copying the cell, it pastes the formula? That is not the default action, but try to paste as value only (https://support.microsoft.com/en-us/office/paste-options-8ea795b0-87cd-46af-9b59-ed4d8b1669ad?redirectsourcepath=%252fen-us%252farticle%252f0636593a-985c-4c34-bcfa-049f470a6596&ui=en-us&rs=en-us&ad=us
If it shows all formula on the sheet you might have hit CTRL+T.

To not show error use this:
=IF(ISERROR(your formula)=TRUE,"",your formula)

Best regards,
Trowa