Hello
I have a list of cells with content like this:
SC2E36C (SC2E36C Measuring Crime)
SC32 (SC3PO2 Community Sector Management Project)
Is there way to delete everything from the space and beyond, so they look like this:
SC2E36C
SC32
Thanks
Hello
I have a list of cells with content like this:
SC2E36C (SC2E36C Measuring Crime)
SC32 (SC3PO2 Community Sector Management Project)
Is there way to delete everything from the space and beyond, so they look like this:
SC2E36C
SC32
Thanks
Try this,
=LEFT(A1,FIND(" ",A1,1)-1)
Thank you for your prompt reply.
=LEFT(A1,FIND(" ",A1,1)-1)
What does the red 1 point to?
Last edited by Editz; 11-09-2006 at 12:43 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks