Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help with unusual request?
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 "poof" a new column would be there with only the data I need... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help with unusual request?
How about some examples.
Check out DataText to Columns. Biff "AWA" wrote in message ... 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 "poof" a new column would be there with only the data I need... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help with unusual request?
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! poof" a new column would be there with only the data I need... --- Regards, Norman "AWA" wrote in message ... 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 "poof" a new column would be there with only the data I need... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help with unusual request?
YOU ROCK! THANK YOU VERY MUCH!!!!
"Biff" wrote: How about some examples. Check out DataText to Columns. Biff "AWA" wrote in message ... 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 "poof" a new column would be there with only the data I need... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help with unusual request?
Assuming your data is seperated by spaces, you can try this in a blank column: =IF(ISERROR(LEFT(A1,FIND(" ",A1)-1)),IF(A1="","",A1),LEFT(A1,FIND(" ",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 "spaces" say "comas" then change FIND(" " to FIND("," in the formula. HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=496061 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP - problem in stock request | Excel Worksheet Functions | |||
Where do I find the Payment Request Wizard in Outlook? | Excel Discussion (Misc queries) | |||
Unusual filter request | Excel Discussion (Misc queries) | |||
How to Create an Excel Macro to send a meeting request. | Excel Discussion (Misc queries) | |||
trendline - request power --> get linear | Excel Worksheet Functions |