Finding the @ character within a text, cell range
Closed
Jaye
-
Aug 31, 2016 at 12:03 AM
TrowaD
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- Finding the @ character within a text, cell range
- Excel reference cell range in another sheet - Guide
- Auto copy and paste cell range to a separate sheet ✓ - Forum - Excel
- Finding a date (N30) in a date range B5:B30 and returning A3text ✓ - Forum - Excel
- Creating pdf from selected cell range ✓ - Forum - Excel
- Emailing selected cell range using outlook ✓ - Forum - Outlook
1 reply
TrowaD
Sep 1, 2016 at 11:19 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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