Excel help separating /
I am working on spreadsheet that has a list of names in the following format: “Your T Name/the company”
I used the following formula to list the last name in an adjacent cell: =IF(ISERROR(SEARCH(" ",A101,SEARCH(" ",A101)+1)),RIGHT(A101,LEN(A101)-SEARCH(" ",A101)),RIGHT(A101,LEN(A101)-SEARCH(" ",A101,SEARCH(" ",A101)+1))) However, since this list includes our internal email address the results are coming up as follows: “Name /the company” Can someone help me by providing a formula to remove the “/the company” from the last name field? |
Excel help separating /
|
Excel help separating /
|
All times are GMT +1. The time now is 02:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com