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?

[Webinar] Streamline your web hosting managementRegister Today

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

Cheers
0
All Courses

From novice to tech pro — start learning today.