Removing first Character

Hi All,

I need your assistance with a macro. I have column A with about 7000 rows, I would like to remove the first character of the cell, only if it begings with a F.

Thanks in advance.
jose11auAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
als315Connect With a Mentor Commented:
=IF(LEFT(A1,1)="F",Right(A1,Len(A1)-1),A1)
0
 
jose11auAuthor Commented:
Thanks als315.

Cheers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.