Experts Exchange connects you with the people and services you need so you can get back to work.
Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
' What I need is VBA that will go through the whole column
' and if it begins with an A, strip it off, then do the mid function.
' =mid(A2, 2, 5)
Public Sub DeletePrefix()
For Each i In Sheets("sheet1").Range("A:A") ' entire 1st column independent of max rows
If Mid(i.Value, 1, 1) = "A" Then
i.Value = Mid(i.Value, 2, 5) 'NOTE: remove last argument to preserve all but the first character
Open in new window
Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
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.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!