Help ME PLZ
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.
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 488 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Help ME PLZi Have A file Which contains the names like this Lokesh & Chitra i want to remove the name and space before and after from "&" so my name look like this Chitra Plz Help Me. |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
formula
you need a formula like this:
=RIGHT(A1,LEN(A1)-FIND("&",A1,1)-1)
Where: Lokesh & Chitra is in cell A1