HELP with code for copy of some rows from Text file to Excel cells

[atoppad]

I have a text file (NOTEPAD) and from there i need a copy some values (10 characters of each row) to Excel cells.

Example

X: +1289.7921 +1287.0000 +000.0000 +000.0000 +0002.7921 +0002.7921
Z: +0247.6581 +0260.0000 +000.0000 +000.0000 -0012.3419 -0012.3419

But I don't know to write a code for that

Copy characters from 4 to 13 of row 1

[taps]

Hi,

Welcome in Excel Forum.

What would be the answer. Can you mention it?


regards
taps

[atoppad]

Hi taps,

I'm looking for solution of my problem
I know the code for copying whole row form Text file to Excel cell but I don't know, the code for something special - copy characters 4-13 from row 1 ONLY (I'm not expert in Excel)

[taps]

Hi,

You can use MID function.

Syntax is:
=Mid(text, starting number, number of characters to retrieve)

Here, your code could be

Please Login or Register  to view this content.

Note: you can use cell address in place of "Your text"

regards
taps

[atoppad]

Ya, it works!!!!

Thanks for your help Taps

regards

[Cutter]

@ atoppad

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.