Middle name extraction [Closed]

Question

Middle name extraction [Closed]

Report

Tulika - Sep 29, 2016 at 04:56 AM
TrowaD

Posts: 2717
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 1, 2021

- 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?

Middle name extraction
Extract audio from mov - How-To - VLC
Extract script from youtube - How-To - YouTube
Internal error occurred while extracting installation files ✓ - Forum - Antivirus
Extract hyperlinks from word document - How-To - Word
Extract and install tar.gz - How-To - Ubuntu

1 reply

Ask a question

TrowaD · Answer 1 · 2016-10-04T11:53:45-0400

Answer 1 / 1

TrowaD

Posts: 2717
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 1, 2021

458
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

Middle name extraction [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!