If cell starts with semicolon, remove semicolon

try this one

"=IF(LEFT(Q2,1)="";"",RIGHT(Q2,LEN(Q2)-1),Q2)"

You get better help with your question if you add a small example of your Excel file, without confidential infomation on this forum. Including your code.

I have one more question if you do not mind Fluff13. I am just working with a small sampling of what will be a large spreadsheet. Because of that and speed considerations, I changed the code to read like below. It works fine, however, some cells begin with 1 or 2 or 3 or 4 semicolons. I want to be able to loop through each cell in my column until all the leading semicolons are gone. I have tried but not luck yet. The code below will only remove 1 semicolon. I am thinking I either need to incorporate and If statement or a Do while loop but I just do not know how in this context.

# With ThisWorkbook.Worksheets("Sheet1")
# lastrow = .Cells(.Rows.Count, 1).End(x1Up).Row
# With Range("Q2:Q" & lastrow)
#.Value = Evaluate(Replace("IF(LEFT(@,1)="";"",replace(@,1,1,""""),@)", "@", .Address))
# End With

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)