Replace Help Please

B

Bryan Bloom

I have a spreadsheet with all kinds of names in one column. The names are in
rows.

Each of the names are for example - moving san diego, del mar moving...

I want to replace each of them so that there is a " at the start and a " at
the end.

I tried to find * and replace with "*" but that doesn't work. Any
suggestions are appreciated.

Thank you so much.

Bryan
 
R

RagDyer

With names starting in A1, enter this in B1:

=""""&A1&""""

And copy down as needed.

Then, to remove the formula, and leave the revised data behind,
Select the data in ColumnB,
Right click in the selection and choose "Copy",
Right click again and choose "Paste Special",
And click on "Values", then <OK>, then <Esc>

You now have 2 columns of data,
One with, and the other without quotes.
 
B

Bryan Bloom

RD - thanks for the respones, this would work, but I asked the question
incorrectly.

What I have is a cell with quotation marks such as "moving san francisco"
What I want to end up with in the cell is just moving san francisco without
the quotations in front and at the end of the phrase.

How do I do that? Do i use replace or a formula? thanks again.

Bryan
 
G

Gord Dibben

Just select the column and Edit>Replace

What: "

With: nothing

Replace all.


Gord Dibben MS Excel MVP
 
B

Bryan Bloom

Thank you so much. It worked!!!!!

Bryan

Gord Dibben said:
Just select the column and Edit>Replace

What: "

With: nothing

Replace all.


Gord Dibben MS Excel MVP
Click to expand...
 
Top