Middle name extraction

Closed
Tulika - Sep 29, 2016 at 04:56 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Oct 4, 2016 at 11:53 AM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Oct 4, 2016 at 11:53 AM
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
0