RE: Can I use an "If, then" function here...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


If the number of numerics after the dot is not fixed; and if the text string
always contain only one dot. you can use this..which will extract the
characters after the first dot.

=MID(A1,FIND(".",A1)+1,LEN(A1))

If this post helps click Yes
---------------
Jacob Skaria


"jkramos2005" wrote:

I have a range of accounts:

022.9700
000.4500
001.9600
r100.R9500


For those with no "r" I want to use a function of:

=right(cell location, count four characters from the right)


So for the first line the value returned would be:

9700

But for the fourth line I would like the value returned to be:

R9500

How would I adjust my formula so that I just use one formula for the whole
range of data?

Any help would be most appreciated.

Thanks!
.

Relevant Pages

  • Re: Using periods/dots within file names
    ... My partner and I have used and successfully tested what I created and refer to as the Dot Notation File Naming Schema. ... Have fun with your "descriptive" naming noting the only legitimate and required limits are those imposed by the file system which limits the total number of alphanumeric characters in the string used to name a file noting the. ... As I recall even the 8.3 file naming convention allowed us to delineate file names using any number of dots noting we only had 8 characters to work with for the name so doing so was not as practical as we can now take advantage of on the Windows file system which support 256 characters in a file name. ...
    (microsoft.public.dotnet.general)
  • Re: extract chars after a last dot
    ... > how do i extract the characters after the last dot? ... If you use bash, you can do this: ...
    (comp.unix.shell)
  • Re: The downsides of pseudo-historical fiction
    ... characters in a variety of roles, ... While blackness is clearly more politically correct than ... whether whales are more politically correct than native ... email to oshea dot j dot j at gmail dot com. ...
    (rec.arts.sf.composition)
  • Re: Language Selcection Philosophy
    ... sure the Germans can handle using a dot instead of a comma and are probably forced to by many other systems or 2) This can be selected at run-time and I can modify my DrawDecimalfunction to reference a variable before is draws a comma or a dot. ... Remember different languages require different characters - even Latin alphabet texts often have accented characters. ... You can get around a lot of it if you use printf variants for your display, and let the format strings also be language-dependant. ...
    (comp.arch.embedded)
  • Re: extract chars after a last dot
    ... On Mon, 04 Aug 2003 at 11:22 GMT, mike wrote: ... > how do i extract the characters after the last dot? ...
    (comp.unix.shell)