Home » Forums » Open Source Learning Center » Question and Answer

Help ME PLZ

Submitted by Anonymous on 31 May, 2010 - 11:01

i Have A file Which contains the names like this

Lokesh & Chitra
Adam & EVE
Paul & Nina

i want to remove the name and space before and after from "&" so my name look like this

Chitra
EVE
Nina

Plz Help Me.

‹ Prevent Data entry once date has passed How to get the event for application window resize ›
»
Nick's picture

formula

Submitted by Nick on 31 May, 2010 - 16:00.

you need a formula like this:

=RIGHT(A1,LEN(A1)-FIND("&",A1,1)-1)

Where:  Lokesh & Chitra    is in cell A1

»