Excel Import - remove first 5 characters in a cell

I have 1000's of records in a spreadsheet. I one of the columns I have information that i need to remove the first 5 characters.
I can't figure it out for the life of me...
Thank you!
greentatertot1970Asked:
Who is Participating?
 
Patrick MatthewsCommented:
In another column, use a formula like this:=MID(A2,6,LEN(A2))Copy that down as needed.  Now, copy the results in that new column, and do a Paste Special / Values over the originals.Delete that "helper" column with the formulas, and voila.
0
 
greentatertot1970Author Commented:
Excellent - thank you!
I wish I could figure that out on my own! :-)
0
Question has a verified solution.

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.

All Courses

From novice to tech pro — start learning today.