I have a column of cells that all look like this: Name: American Renal Associates Holdings Inc
I want to get rid of "Name:" So I am just left with the other words. Is there a way to get rid of the first word (which in this case is always "Name:")? And I'd like to apply this to the entire column.
Thanks in advance!
I want to get rid of "Name:" So I am just left with the other words. Is there a way to get rid of the first word (which in this case is always "Name:")? And I'd like to apply this to the entire column.
Thanks in advance!