If you need the more shortcut then I can develop a macro for that
On Wed, Sep 22, 2010 at 4:45 PM, Sanjoy Nath <sanjoy.nath...@gmail.com>wrote: > Just open the notepad and find and replace all the spaces with comma > and after that close the file > and rename the file extension from .txt to .csv > > > see the magic > > reverse process to get the thing in txt again > > > ITS WILL WORK GREAT > > 2010/9/22 Abhidha Dixit <abhidha.di...@gmail.com> > >> Dear ALL >> >> Please help how can i transpose the data from notepad to excel with the >> similar colomn gap so that when we copy this again to notebook i shall get >> the data with the samilar spaces >> >> thanks >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 7000 subscribers worldwide and receive many nice notes about >> the learning and support from the group.Let friends and co-workers know they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > > > -- > Your Sincerely > Sanjoy Nath > Engineer > EOL Gurgaon > EOL/M/NZ/Engg.Dept.(Haryana Division) > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe