help me "" and [ ] in excel easier.

You guys know what I mean.

[JustinH]

I'm using excel to run my adwords campaigns. It works pretty well, except I'm trying to find a excel command to put "Quotes" and [Brackets] around each of my search terms. I can't figure out how to format a group of cells to make them all have quotes, then do it again to make them all have brackets.

It just saves me alot of typing and alot of cut/pasting.

Thanks,
Justin

[PPCBidder]

hmmm... I usually hack such things out by using another column and abusing concatenate.

Like if my term is in A1 in B1 I'll fill something like: =CONCATENATE("[",A1,"]") - and then piece each line together further right in the document

Perhaps someone else has a more elegant solution but it works for me. (I use 'concatenate' and 'if' for everything)

[skibum]

Yep, not the most efficient but it gets the job done. One of these days it'll be time to learn more about Excel.:)

[claus]

Term you want in quotes/brackets is in cell A1

In another cell, type:

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

or

="["&A1&"]"

- it's four quotes on each side of the ampersand.

[JustinH]

Awesome, thanks claus.

His works the best.

Thanks excel geeks.

[PPCBidder]

Bleh, it's exactly the same thing, only my advice uses the built in function. Now if you needed additional help or tips on how to use this feature, which post would help you more, eh? Plus you can use the 'time saving' wizard thingy if you so choose. =P

[fclark]

Now, go do it in Access.

[FromRocky]

PPCBidder & Claus,
Good tips!