On the off change that some of your text could contain more than one comma,
like for instance...

123 Main St, Apt 4, New York 56789

then you can use this formula to get the text that you want...

=TRIM(RIGHT(SUBSTITUTE(A1,",",REPT(" ",99)),99))

--
Rick (MVP - Excel)


"andreas" wrote in message
...
Dear Experts:

I got the following string in a cell:

string,space,string, e.g.: New York Street 7, New York 54334 or
Green Street, 74334 St. Petersburg.


I would like to apply a formula to all these cells so that all the
characters before the comma are cut out and only the string after the
comma is left over, e.g. New York 54334 or 74334 St. Petersburg

Help is much appreciated. Thank you very much in advance.
Regards, Andreas