Middle name extraction
Closed
Tulika
-
Sep 29, 2016 at 04:56 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 4, 2016 at 11:53 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 4, 2016 at 11:53 AM
Related:
- Middle name extraction
- Tom clancy's rainbow six extraction pc download - Download - Shooters
- Lg tv closed caption in middle of screen - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Oct 4, 2016 at 11:53 AM
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
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
