How to split a cell in excel using formula ?

siamandm
5StarLounger
Posts: 1192
Joined: 01 May 2016, 09:58

How to split a cell in excel using formula ?

Post by siamandm »

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?
Screenshot 2021-02-12 080509.png

Regards
You do not have the required permissions to view the files attached to this post.

adeel1
3StarLounger
Posts: 264
Joined: 04 Oct 2017, 15:47

Re: How to split a cell in excel using formula ?

Post by adeel1 »

try:
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2,"IQD",""),"IN:",""),"/",REPT(" ",255)),COLUMNS($A$2:A2)*255-254,255))

Adeel
Capture.PNG
You do not have the required permissions to view the files attached to this post.

siamandm
5StarLounger
Posts: 1192
Joined: 01 May 2016, 09:58

Re: How to split a cell in excel using formula ?

Post by siamandm »

thank you very much for your quick reply
Regards