need formula to remove the first word in an excel cell

finnstone asked

on 2017-03-13

4 Comments

1 Solution

97 Views

Last Modified: 2017-03-13

example

need

1 Gary Miller

to

Gary Miller

Comment

Watch Question

View Solution Only

Shums

Managing Director/Excel VBA Developer

CERTIFIED EXPERT

Distinguished Expert 2018

Commented: 2017-03-13

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

finnstone

Author

Commented: 2017-03-13

it will be word sometimes like "Dr."

Shums

Managing Director/Excel VBA Developer

CERTIFIED EXPERT

Distinguished Expert 2018

Commented: 2017-03-13

This problem has been solved!

(Unlock this solution with a 7-day Free Trial)

Shums

Managing Director/Excel VBA Developer

CERTIFIED EXPERT

Distinguished Expert 2018

Commented: 2017-03-13

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

Facebook
Twitter
LinkedIn
https://www.experts-exchange.com/questions/29008782/need-formula-to-remove-the-first-word-in-an-excel-cell.html copy

Get your personalized solution.

Ask The Experts