2 Colums from 1 Row

[pgalvezt]

Im sorry Yes youre right its more complex

[pover]

If the case of the attached excel it would be a simple left(trim(Column1),10) and a right(trim(Column1),10), but in more complex cases the functions subfield(), index() and mid() are useful.

Karl

[pgalvezt]

I put another example Im sorry. I've attached the other example. Thanks!

[pgalvezt]

Anyone?

[#5]

I believe you edit the question...

[pgalvezt]

I put another example. That is the reason

[#7]

But what are we looking at in the excel file?

How do we identify the columns?

[pover]

I don't understand the new excel.