Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Im sorry Yes youre right its more complex
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
I put another example Im sorry. I've attached the other example. Thanks!
Anyone?
I believe you edit the question...
I put another example. That is the reason
But what are we looking at in the excel file?
How do we identify the columns?
I don't understand the new excel.