i have a sheet with only 1 column (A) each cell downward has an entry and it looks like this
A
1 [email protected],"Ernest Vasquez"
and so forth and so forth
i need to remove the ,"Ernest Vasquez" from this cell and paste on a separate column (B) without the , and " " just the plain name. Why not just highlight cell A1 and manually delete the characters?
Well because there are 25,213 entries from A1 to A25213. Gosh!!!
Bookmarks