Replace Help Please

[Guest]

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

 

[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.

 

[Guest]

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

 

[Gord Dibben]

Just select the column and Edit>Replace

What: "

With: nothing

Replace all.


Gord Dibben MS Excel MVP

 

[Guest]

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

Bryan

Just select the column and Edit>Replace

What: "

With: nothing

Replace all.


Gord Dibben MS Excel MVP