We help IT Professionals succeed at work.

need formula to remove the first word in an excel cell

97 Views
Last Modified: 2017-03-13
example

need

1 Gary Miller


to

Gary Miller
Comment
Watch Question

ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
Will this first letter be always numeric? and how many digits?

Author

Commented:
it will be word sometimes like "Dr."
Managing Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
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))

Open in new window