Hey guys,
I have some data that I exported and I have excel parsing it. I am using Text2Columns, but what happens is some employees have there first, middle, and last name in the report. This makes everything on that row shift over by 1 cell to the right. I am wanting to have excel look at one column, find the cells that contain text (A-Z, a-z, etc), delete those cells and shift the cells left. Is that possible?
This forum has been critical to me getting a HUGE project completed for my job. I would like to think everyone who has helped me so far. Thank you!
Bookmarks