"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumReplyMessage:message:4082414"},"conversation":{"__ref":"Conversation:conversation:2534017"},"subject":"Re: why doesn't Excel recognize the TEXTBEFORE() and TEXTAFTER() functions when I tr...
","title":"Excel","shortTitle":"Excel","parent":{"__ref":"Category:category:microsoft365"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:gxcuf89792"}},{"__typename":"CoreNodeEdge","node":{...
why doesn't Excel recognize the TEXTBEFORE() and TEXTAFTER() functions when I try to use them? When I attempt to use these functions, Excel returns the #NAME? error message. Formulas and Functions Like 0 Reply View Full Discussion (14 Re...
1,"uid":2534045,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"conversation":{"__ref":"Conversation:conversation:2534017"},"subject":"Re: why doesn't Excel recognize the TEXTBEFORE() and TEXTAFTER() functions when I try to...
why doesn't Excel recognize the TEXTBEFORE() and TEXTAFTER() functions when I try to use them? donnawomanthanks toChatGPT, I was given this answer which works as desired (in my case, my text was in A4, between a '.' and a '@'):...
Alternatively, you can create your own User Defined Function (UDF), call it whatever you want (as long as it's name doesn't clash with any existing UDFs or standard Excel functions). To learn how to do that is not too tricky, simply reference the UDF documentation for the re...
1,"uid":2534045,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"conversation":{"__ref":"Conversation:conversation:2534017"},"subject":"Re: why doesn't Excel recognize the TEXTBEFORE() and TEXTAFTER() functions when I try to ...
{"__ref":"Conversation:conversation:2534017"},"author":{"__ref":"User:user:521"},"revisionNum":1,"uid":3844624,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"subject":"Re: why doesn't Excel recognize the TEXT...
why doesn't Excel recognize the TEXTBEFORE() and TEXTAFTER() functions when I try to use them? When I attempt to use these functions, Excel returns the #NAME? error message. Like 0 Reply View Full Discussion (14 Replies)Show Parent Replies Patrick2788 Silver Contributor to Serge...
Excel Your community for how-to discussions and sharing best practices on Microsoft Excel. If you’re looking for technical support, please visitMicrosoft Support Community. Forum Discussion