Solved

Removing first Character

Posted on 2012-03-25
2
295 Views
Last Modified: 2012-08-14
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
Comment
Question by:jose11au
2 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 37764361
=IF(LEFT(A1,1)="F",Right(A1,Len(A1)-1),A1)
0
 

Author Comment

by:jose11au
ID: 37764411
Thanks als315.

Cheers
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question