Solved

Removing first Character

Posted on 2012-03-25
2
293 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
Comment Utility
=IF(LEFT(A1,1)="F",Right(A1,Len(A1)-1),A1)
0
 

Author Comment

by:jose11au
Comment Utility
Thanks als315.

Cheers
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now