Excel help
Solved/Closed
ceejaydee
-
23 Jul 2010 à 14:47
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 27 Jul 2010 à 07:56
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 27 Jul 2010 à 07:56
Related:
- Excel help
- Excel mod apk for pc - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Excel clear formatting - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
23 Jul 2010 à 17:47
23 Jul 2010 à 17:47
Chris, try this
=IF(A1="","",MID(LEFT(A1,IF(ISERROR(FIND("]",A1)),LEN(A1),FIND("]",A1))-1),IF(ISERROR(FIND("[",A1)),1,FIND("[",A1)+1),LEN(A1)))
=IF(A1="","",MID(LEFT(A1,IF(ISERROR(FIND("]",A1)),LEN(A1),FIND("]",A1))-1),IF(ISERROR(FIND("[",A1)),1,FIND("[",A1)+1),LEN(A1)))
26 Jul 2010 à 21:23
Works like a charm. Thank you very much. If you should ever need help with chemistry, look me up. I'm sure ill post again soon.
27 Jul 2010 à 07:56