| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function
I'm trying to separate out this data that is stored in one field: Sari Panama - Pacific Point I need to basically write a function that extracts Panama - Pacific Point out and puts it into a new field but am not having any luck with the help in Excel for this function. Can anyone help?? -- gemispence ------------------------------------------------------------------------ gemispence's Profile: http://www.excelforum.com/member.php...o&userid=37113 View this thread: http://www.excelforum.com/showthread...hreadid=568449 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
use the text to column tool use the other section (after pressing the next button) to put the " - " in and hey presto, they are split... HTH -- mr_ben ------------------------------------------------------------------------ mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106 View this thread: http://www.excelforum.com/showthread...hreadid=568449 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
Thanks...Where is the Text to Column Tool though? Also, there is different types of projects in this field that i need to split out (ie - panama - project is just one of them). :) -- gemispence ------------------------------------------------------------------------ gemispence's Profile: http://www.excelforum.com/member.php...o&userid=37113 View this thread: http://www.excelforum.com/showthread...hreadid=568449 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
Try this, assuming your data is in A1:
=MID(A1,FIND(CHAR(10),A1,1)+1,LEN(A1)) HTH, Elkar "gemispence" wrote: I'm trying to separate out this data that is stored in one field: Sari Panama - Pacific Point I need to basically write a function that extracts Panama - Pacific Point out and puts it into a new field but am not having any luck with the help in Excel for this function. Can anyone help?? -- gemispence ------------------------------------------------------------------------ gemispence's Profile: http://www.excelforum.com/member.php...o&userid=37113 View this thread: http://www.excelforum.com/showthread...hreadid=568449 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
it's under the "data" menu as long all have " - " (ie [space]-[space]) then it will work -- mr_ben ------------------------------------------------------------------------ mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106 View this thread: http://www.excelforum.com/showthread...hreadid=568449 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
That's really helpful thanks, but the problem is that the space between the two values isn't always in the same spot, and the text to columns command looks like it needs me to specify where the break should occur. The problem is that b/c it's not always in the same spot then it will break words at times. -- gemispence ------------------------------------------------------------------------ gemispence's Profile: http://www.excelforum.com/member.php...o&userid=37113 View this thread: http://www.excelforum.com/showthread...hreadid=568449 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
gemispence Wrote: That's really helpful thanks, but the problem is that the space between the two values isn't always in the same spot, and the text to columns command looks like it needs me to specify where the break should occur. The problem is that b/c it's not always in the same spot then it will break words at times. no, text to columns doesn't "care" where the characters are as long as the appear in that form, if they appear more than once in that style then the text is split in more than 2 columns. 1: make sure you've selected delimited on the first step 2: in the next step in other type - (just found out that it only accpets one character :oops: ) 3: then you can finish if you accept the next screen -- mr_ben ------------------------------------------------------------------------ mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106 View this thread: http://www.excelforum.com/showthread...hreadid=568449 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
That almost worked, except that some cells are getting separated when I don't want them to. I think what would be better would be to use some conditional logic to extract the text that I want from the cells into a new cell. Which goes back to my initial question. For example, here is a copy of two of the cells: " Sari Allegro Palm" or " Sari Panama - Pacific Point" or " Sari Preserve at Temple Terrace" so i need to construct an IF statement that says something like if Preserve at Terrace, insert Preserve at Terrace into a new field. :) -- gemispence ------------------------------------------------------------------------ gemispence's Profile: http://www.excelforum.com/member.php...o&userid=37113 View this thread: http://www.excelforum.com/showthread...hreadid=568449 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
