Hey Anil,
this post sent by mr.Bob
If you want to import a text file into Excel and have that data be in
multiple columns once it's in Excel, it must be either fixed width or
delimited. Fixed-width means that new columns occur at the same place on
every line. That's not very useful for most information. Delimited means
that some ASCII character occurs wherever you want a column break. Usually
this character is a tab. If you had address information and wanted the
Street, City, and State in different columns, your data would have to look
like:
Street {tab} City {tab} State
If you have your data in a table in Word, you're going to want to convert it
to text. When you select Table > Convert > Table to Text, Word will ask you
what it should separate the text with. In other word, it wants to know what
it should use as the delimiter. You can use any ASCII character, but I would
suggest a tab or some other character that isn't use in your data. Whatever
you choose, just remember to tell Excel to use it as the delimiter when it
imports your data.
If you data in Word and is *not* in a table, just save it as Text Only With
Line Breaks (.txt) so that every line goes in a different row (assuming
that's what you want). When in Excel, you can use Text to Columns to parse
it into different columns.
On Mon, Aug 29, 2011 at 9:46 AM, anil kumar <kmr7a...@gmail.com> wrote:
> Hi friends,
>
>
> I want to know that how to change msword file into excel plz reply
> verey urgent.
>
>
>
>
> Thanks & Regards
>
> Anil
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
.........................
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
