I have an excel file I import. It is a database with 600+ records. After I import one field is called itemno, It has 7 to 8 digits with no spaces. I need to change it so it has a space between the fourth and fifth digit. I tried a macro by starting to record making it relative, then hitting F2(to edit), then the home key to go to the start of the field, then I hit the right arrow 4 times, then I add a space, then hit enter. It jumps to the next row. I thought this would work, but it repeats the number from the first cell over and over in every cell instead of adding a space to the data that was in that cell. I have tried everything I know.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.