Middle name extraction [Closed]

Report
-
Posts
2717
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 1, 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
2717
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 1, 2021
458
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!