How could I separate the numbers 1-1-1 from the string and put it for each row?

Hello.

I’m trying to separate the numbers “1-1” o “1-1-1” from the string in the column "TAREA “Archivo Contrata” and It has to be pasted in the column “Tarea Origen” from the sheet “Hoja1”.

What It is :
image

Desired Output

image

I was trying with :

Write cell activity but It didn’t work.
“=MID(C5,1,SEARCH(’ ',C5,1))”
Any idea, please.

I’m uploading the excel file.
Columna.xlsx (184.8 KB)

@pprin001
This should have what you need

Regards

Hey @pprin001,
You can try this.

Testing1.xaml (8.3 KB)

Please mark this as solution if this helps you,

Regards,

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.