Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract only part of a string
On Jul 20, 6:01*pm, Sam Wilson
wrote: If you had the string in cell A1: =TRIM(RIGHT(A1,LEN(A1)-FIND(",",A1))) "andreas" wrote: 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- Hide quoted text - - Show quoted text - ok, thank you very much for your terrific help. It works, Regards, Andreas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract only part of a string | Excel Programming | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
Extract part of a text string | Excel Worksheet Functions | |||
How do I extract part of a text string | Excel Discussion (Misc queries) | |||
Extract Part of String | Excel Worksheet Functions |