Technical Discussion
  >> Windows Issues


Register (or login) on our website and you will not see this ad.


These posts have been archived and can no longer be replied to or modified.
  Print Thread
Standard User deleted
(deleted) Thu 19-Jul-07 18:56:49
Print Post

Excel Help.....again


[link to this post]
 
I have a set of text strings which all end in a number.

Currently what I am having to do is use this formula

=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

But as there is no space but an "=" sign before the last number I am putting in the formula and then doing a find replace for = and replacing it with a space.

so for example I have the string

itemgg=321283

I put the formual in as above then replace the = with a space to return just 321283. Can I change the formula somehow to cut the find and replace out?

Cheers
Standard User chippy2
(fountain of knowledge) Thu 19-Jul-07 23:16:09
Print Post

Re: Excel Help.....again


[re: deleted] [link to this post]
 
What is it you are trying to do - pick the number, which is separated from the rest of the string by "=", off the end of the string?
Standard User planetbrain
(learned) Fri 20-Jul-07 12:35:42
Print Post

Re: Excel Help.....again


[re: deleted] [link to this post]
 
It wasn't clear if to me if required the leading space, and typing your formula gave me an error anyway !

Try

=RIGHT(A1,(FIND("=",A1))-1) which would return "321283" (without the quotes)

or

=CONCATENATE(" ",RIGHT(A1,(FIND("=",A1))-1)) which would return " 321283" (without the quotes)



you may be right, but I'm not wrong

madasafish


Register (or login) on our website and you will not see this ad.

  Print Thread

Jump to