Finding the @ character within a text, cell range
Closed
Jaye
-
31 Aug 2016 à 00:03
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 1 Sep 2016 à 11:19
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 1 Sep 2016 à 11:19
Related:
- Finding the @ character within a text, cell range
- Mac pipe character - Guide
- How to increase wifi range - Guide
- Excel vba range find - Guide
- Ascii character - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as named ranges. ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
1 Sep 2016 à 11:19
1 Sep 2016 à 11:19
Hi Jaye,
Try this:
=IF(ISERROR(FIND("@",A1)),"",1& " " ) & IF(ISERROR(FIND("@",A2)),"",2)
Best regards,
Trowa
Try this:
=IF(ISERROR(FIND("@",A1)),"",1& " " ) & IF(ISERROR(FIND("@",A2)),"",2)
Best regards,
Trowa
