View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Magwine Magwine is offline
external usenet poster
 
Posts: 1
Default Remove first few digits from all cells in the column

I believe this has something to do with function LEFT or RIGHT in Excel.
Specifically, I want to take out the first two digits and a space (the
numbers) in all cells of the column, making it names only. So, "1. Vince
Higgs" would become "Vince Higgs" and "2. Joe Blow" would become "Joe Blow"
I have no experience with macros and little with functions, but have been
experiementing with simple functions like TODAY.

Thank you.