About
Pricing
Community
Teams
Start Free Trial
Log in
finnstone
asked on
3/13/2017
need formula to remove the first word in an excel cell
example
need
1 Gary Miller
to
Gary Miller
Microsoft Excel
Microsoft Office
4
1
Last Comment
Shums Faruk
8/22/2022 - Mon
Shums Faruk
3/13/2017
Will this first letter be always numeric? and how many digits?
finnstone
3/13/2017
ASKER
it will be word sometimes like "Dr."
ASKER CERTIFIED SOLUTION
Shums Faruk
3/13/2017
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Shums Faruk
3/13/2017
If you want to drag the formula down all the rows, below formula will take care of blanks:
=IF(A2="","",MID(A2,FIND(" ",A2)+1,256))
Select all
Open in new window
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23