macro to combine text and text/value in cell

[cullenm]

In a new cell I want to be able to click one button and have any cells i select show up in the following format;

"[data 1]" or like "[data 2]" or like "[data 3]"

Im not sure how to make the quotation marks appear. It also needs to be for any amount of data from cells in one column. Any macro suggestions would be helpful!

Example: If i select these 5 data points in one column

10
11f
245366-b
4
11

i need something like this to show up in another cell: "10" or like "11f" or like "245366-b" or like "4" or like "11"

[BigBas]

Does this do the trick?

Please Login or Register  to view this content.

[cullenm]

this works great! thanks!
is there an easy way to get the

or like

off of the last number for the macro? i can always just delete it too.. so its not big deal.

[BigBas]

I hadn't even noticed that. Try this modified code (you should never have to manual deletions! We're trying to save time here!!):

Please Login or Register  to view this content.