i have a sheet with only 1 column (A) each cell downward has an entry
and it looks like this
A
1 ,"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!!!


--
djranks
------------------------------------------------------------------------
djranks's Profile: http://www.excelforum.com/member.php...fo&userid=3704
View this thread: http://www.excelforum.com/showthread...hreadid=494301