software

I just need to seperate data in an exisiting column microsoft excel. For
example, I have too much data in a particular column, I do not need all of
that data - just (the first) part of the data. If only I could draw a
vertical line and quot;poofquot; a new column would be there with only the data I
need...

How about some examples.

Check out Datagt;Text to Columns.

Biff

quot;AWAquot; gt; wrote in message
...
gt;I just need to seperate data in an exisiting column microsoft excel. For
gt; example, I have too much data in a particular column, I do not need all of
gt; that data - just (the first) part of the data. If only I could draw a
gt; vertical line and quot;poofquot; a new column would be there with only the data I
gt; need...
Hi AWA,

Select the data
Data | Text to Columns | Fixed width | Next |
Click where you want the column break | Next
For unwanted data, check the 'Do not import column' option
Poof!

gt; poofquot; a new column would be there with only the data I need...

---
Regards,
Norman
quot;AWAquot; gt; wrote in message
...
gt;I just need to seperate data in an exisiting column microsoft excel. For
gt; example, I have too much data in a particular column, I do not need all of
gt; that data - just (the first) part of the data. If only I could draw a
gt; vertical line and quot;poofquot; a new column would be there with only the data I
gt; need...
YOU ROCK! THANK YOU VERY MUCH!!!!

quot;Biffquot; wrote:

gt; How about some examples.
gt;
gt; Check out Datagt;Text to Columns.
gt;
gt; Biff
gt;
gt; quot;AWAquot; gt; wrote in message
gt; ...
gt; gt;I just need to seperate data in an exisiting column microsoft excel. For
gt; gt; example, I have too much data in a particular column, I do not need all of
gt; gt; that data - just (the first) part of the data. If only I could draw a
gt; gt; vertical line and quot;poofquot; a new column would be there with only the data I
gt; gt; need...
gt;
gt;
gt;


Assuming your data is seperated by spaces, you can try this in a blank
column:

=IF(ISERROR(LEFT(A1,FIND(quot; quot;,A1)-1)),IF(A1=quot;quot;,quot;quot;,A1),LEFT(A1,FIND(quot;
quot;,A1)-1))
copied down...once you have done that just copy and paste over your
existing data (Paste as Values).

NOTE! if your data is seperated by something other than quot;spacesquot; say
quot;comasquot; then change FIND(quot; quot; to FIND(quot;,quot; in the formula.

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=496061