Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Find
I have a list of error messages that include text like << "field name"
must be entered in the following format dd-mm-yyyy. I want to be able to trim the messages down to the << the must be entered in the following format dd-mm-yyyy portion, removing the <<" field name" bit. So I'm using something like: =(FIND("field name", E4)),E4,RIGHT(E4,LEN(E4)-12) This checks to see if it can find 'field name' and if it can, removes the first 12 characters. Easy. The problem is I only want this to happen if the _first part_ of the string is 'field name'. So I don't want <<The first character of "field name" must not be D,F,I,Q,U or V to match. Apart from solutions based on the length of these error messages, is there anything else I could try? Thanks, Joe. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Find
Maybe something like this:
=IF(LEFT(E4,10)="field name",RIGHT(E4,LEN(E4)-11),E4) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Joe Murphy" wrote: I have a list of error messages that include text like << "field name" must be entered in the following format dd-mm-yyyy. I want to be able to trim the messages down to the << the must be entered in the following format dd-mm-yyyy portion, removing the <<" field name" bit. So I'm using something like: =(FIND("field name", E4)),E4,RIGHT(E4,LEN(E4)-12) This checks to see if it can find 'field name' and if it can, removes the first 12 characters. Easy. The problem is I only want this to happen if the _first part_ of the string is 'field name'. So I don't want <<The first character of "field name" must not be D,F,I,Q,U or V to match. Apart from solutions based on the length of these error messages, is there anything else I could try? Thanks, Joe. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Max from Variable Range | Excel Worksheet Functions | |||
Cells.Find with a variable | Excel Discussion (Misc queries) | |||
Right Text - Variable Find | Excel Discussion (Misc queries) | |||
3 variable find and replace | Excel Discussion (Misc queries) | |||
How do I find the last row of data and then use that as a variable | New Users to Excel |