Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

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.
0
jose11au
Asked:
jose11au
1 Solution
 
als315Commented:
=IF(LEFT(A1,1)="F",Right(A1,Len(A1)-1),A1)
0
 
jose11auAuthor Commented:
Thanks als315.

Cheers
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now