need formula to remove the first word in an excel cell

finnstone
finnstone used Ask the Experts™
on
example

need

1 Gary Miller


to

Gary Miller
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ShumsManaging Director/Excel VBA Developer
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
Distinguished Expert 2018
Commented:
Assuming your data is in cell A2, try below:
=MID(A2,FIND(" ",A2)+1,256)

Open in new window

ShumsManaging Director/Excel VBA Developer
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial