Hello All
if I have a cell ( Yellow one ) and wanted to split it like the orange one using functions how to do it, please?
Regards
How to split a cell in excel using formula ?
-
- 5StarLounger
- Posts: 1192
- Joined: 01 May 2016, 09:58
How to split a cell in excel using formula ?
You do not have the required permissions to view the files attached to this post.
-
- 3StarLounger
- Posts: 264
- Joined: 04 Oct 2017, 15:47
Re: How to split a cell in excel using formula ?
try:
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2,"IQD",""),"IN:",""),"/",REPT(" ",255)),COLUMNS($A$2:A2)*255-254,255))
Adeel
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2,"IQD",""),"IN:",""),"/",REPT(" ",255)),COLUMNS($A$2:A2)*255-254,255))
Adeel
You do not have the required permissions to view the files attached to this post.
-
- 5StarLounger
- Posts: 1192
- Joined: 01 May 2016, 09:58
Re: How to split a cell in excel using formula ?
thank you very much for your quick reply
Regards
Regards