Formula Needed to Omit Characters




Is there a formula that would recognize and omit specific characters
within a field?

Example:

Data Field has the following 9 characters "R0502AA01".

Only the following 7 characters: "R0502--01" should be picked up or
recognized.

What formula will pick up the 1st-5th and the 8th-9th characters and
bypass the 6th & 7th characters?

Addie


--
addie
------------------------------------------------------------------------
addie's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25526
View this thread: http://www.excelforum.com/showthread.php?threadid=513674

.



Relevant Pages

  • Re: Cannot find datasource
    ... by tab characters or commas, and data records separated by ... Make sure to use the same field delimiter in ... To leave a data field blank for a specific record, ...
    (microsoft.public.word.docmanagement)
  • Re: parsing tab and newline delimited text
    ... separated by newline characters, while fields within each entry are ... My first question is whether the line contains actual newline/tab ... all part of the same data field. ...
    (comp.lang.python)
  • Re: SetValue returns Type mismatch... WHY?!?!
    ... To get the first 80 characters, ... display the value of one data field if another data field contains the ... The Text15 text box is unbound ... I'm using the String function to only get the first 80 characters. ...
    (microsoft.public.access.macros)
  • Re: Date to 4 byte string
    ... The question Jon raises is that it's possible that the OP has 4 characters, not 4 bytes, in which to store the data. ... Depending on how those characters are stored, the OP could have more flexibility or less as compared to a 32-bit data field. ... Of course, if it really is a 32-bit data field in which the OP can store the data, then the character question is moot. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Formula Needed to Omit Characters
    ... As long as your data is always in the same format (9 characters with ... the 6th & 7th being the data to omit), ... SteveG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7571 ...
    (microsoft.public.excel.worksheet.functions)