software

i have a sheet with only 1 column (A) each cell downward has an entry
and it looks like this
A
1 ,quot;Ernest Vasquezquot;

and so forth and so forthi need to remove the ,quot;Ernest Vasquezquot; from this cell and paste on a
separate column (B) without the , and quot; quot; 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: www.excelforum.com/member.php...foamp;userid=3704
View this thread: www.excelforum.com/showthread...hreadid=494301Select Column A.
Choose Text to Columns on the Data menu.
Leave it set to delimited.
Select the comma check box.
Type a quotation mark in the Other box and select its check box.
You should now have have the Comma and Other check boxes selcted. You can
clear the rest of them.
Select the Treat consecutive delimiters as one check box.
Click Finish.
--
tjquot;djranksquot; wrote:

gt;
gt; i have a sheet with only 1 column (A) each cell downward has an entry
gt; and it looks like this
gt; A
gt; 1 ,quot;Ernest Vasquezquot;
gt;
gt; and so forth and so forth
gt;
gt;
gt; i need to remove the ,quot;Ernest Vasquezquot; from this cell and paste on a
gt; separate column (B) without the , and quot; quot; just the plain name. Why
gt; not just highlight cell A1 and manually delete the characters?
gt;
gt;
gt; Well because there are 25,213 entries from A1 to A25213. Gosh!!!
gt;
gt;
gt; --
gt; djranks
gt; ------------------------------------------------------------------------
gt; djranks's Profile: www.excelforum.com/member.php...foamp;userid=3704
gt; View this thread: www.excelforum.com/showthread...hreadid=494301
gt;
gt;

Hi!

Select the data in question.

Make sure there is an empty column to the immediate right where the names
will be extracted to.

Goto Datagt;Text to Columns
Delimitedgt;Next
Delimiters: Check Other and in the box enter quot;
Finish

Biff

quot;djranksquot; gt; wrote in
message ...
gt;
gt; i have a sheet with only 1 column (A) each cell downward has an entry
gt; and it looks like this
gt; A
gt; 1 ,quot;Ernest Vasquezquot;
gt;
gt; and so forth and so forth
gt;
gt;
gt; i need to remove the ,quot;Ernest Vasquezquot; from this cell and paste on a
gt; separate column (B) without the , and quot; quot; just the plain name. Why
gt; not just highlight cell A1 and manually delete the characters?
gt;
gt;
gt; Well because there are 25,213 entries from A1 to A25213. Gosh!!!
gt;
gt;
gt; --
gt; djranks
gt; ------------------------------------------------------------------------
gt; djranks's Profile:
gt; www.excelforum.com/member.php...foamp;userid=3704
gt; View this thread: www.excelforum.com/showthread...hreadid=494301
gt;