• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2864
  • Last Modified:

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!
0
greentatertot1970
Asked:
greentatertot1970
1 Solution
 
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

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now