Finding the @ character within a text, cell range
Closed
Jaye
-
Aug 31, 2016 at 12:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Sep 1, 2016 at 11:19 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Sep 1, 2016 at 11:19 AM
Related:
- Finding the @ character within a text, cell range
- Pipe character mac - Guide
- How to change the dinosaur game character - 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 range names. ✓ - Excel Forum
- Excel Macro/Code help: Creating sheet for each name in column of another sheet ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Sep 1, 2016 at 11:19 AM
Sep 1, 2016 at 11:19 AM
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
