Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
dte123
 
Posts: n/a
Default how do I convert a non exel tabulation to exel

I use a fixed tabulation in my job and I have noticed other people are
converting it to exel for ease of use. I do not want to have to ask and so I
need help.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Thansal
 
Posts: n/a
Default how do I convert a non exel tabulation to exel

Depends on how it is formated.

The only one I have any experiance with is converting a txt file over
to Excel.

In the case of a txt file just open it in Excel and Excel will ask you
how you wana handel it. If the file is evenly spaced (ala tabs) then
it iwll pick up on this and convert, if it is sperated by a specific
character ("," ";" "-" what ever) you can tell it to break by those as
well.

hth
dte123 wrote:
I use a fixed tabulation in my job and I have noticed other people are
converting it to exel for ease of use. I do not want to have to ask and so I
need help.


  #3   Report Post  
Posted to microsoft.public.excel.newusers
JLatham
 
Posts: n/a
Default how do I convert a non exel tabulation to exel

Thansal has given a good answer. I'll go one further with it. During the
input process it will show you where it thinks fields should start/end. It
may not always be right, especially if two or more fields are tail-to-head
like:
jlatham123456 NYC
It might think jlatham123456 is just one field instead of two. It will
allow you to define additional field breaks or delete any that it guessed
wrong on also. So just check on all of them the first time through it.

"Thansal" wrote:

Depends on how it is formated.

The only one I have any experiance with is converting a txt file over
to Excel.

In the case of a txt file just open it in Excel and Excel will ask you
how you wana handel it. If the file is evenly spaced (ala tabs) then
it iwll pick up on this and convert, if it is sperated by a specific
character ("," ";" "-" what ever) you can tell it to break by those as
well.

hth
dte123 wrote:
I use a fixed tabulation in my job and I have noticed other people are
converting it to exel for ease of use. I do not want to have to ask and so I
need help.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert displayed number to absolute value jmorris305 Excel Discussion (Misc queries) 3 February 28th 06 01:27 AM
CONVERT Function Disappered in Excel Gord Dibben Excel Discussion (Misc queries) 3 April 13th 05 07:59 PM
How do I convert imperial to metric in Exel? Struttrogers Setting up and Configuration of Excel 1 January 23rd 05 06:33 PM
How do I convert exel spreadsheet to works spreadsheet? tareco Excel Discussion (Misc queries) 3 December 27th 04 11:20 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM


All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"