Txt\string to datatable

Hi All

How can I transfer data from a text format to a table in the same form as the original?
Screenshot_3 ------> Screenshot_4

The problem is that it ignores deserts cells and leaves only 3 values
Screenshot_5

@Aibek_Abubakirov

Check attached

testtttt.zip (23.1 KB)

Mark as solution if this helps

Thanks

but how to get rid of extra lines?

@Aibek_Abubakirov

as you said below

Screenshot_4

It will create by leaving the spaces exactly

Can you share sample excels and the output you require?

Thanks

test.txt (54 Bytes) tessttt.xlsx (8.6 KB)

@Aibek_Abubakirov

Check attached

testtttt.zip (54.5 KB)

Mark as solution if this works for you

Thanks

image

only one value comes out

@ksrinu070184 or can it be done with a Excel macros?

@Aibek_Abubakirov

For me it rans fine, you can download below attachment, remove all from excel sheet and try

testtttt.zip (23.4 KB)

check once again

I tried, only one value comes out

Thanks a lot for the help, I solved the problem using VBA

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