View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Michael Koerner Michael Koerner is offline
external usenet poster
 
Posts: 164
Default Looking for a quick way.

Ron;

That would work, but it italicise the whole cell. I just want to italicise
what is bracketed

--

Regards
Michael Koerner


"Ron Coderre" wrote in message
...[i]
If this is a one-time adjustment, how about this:

Select the range of cells
Hold down [Ctrl] and press [F].....that's a shortcut for <edit<find
Find what: (*)
Click the [Find All] button
-That will list ALL found cells, BUT only select ONE
Hold down [Ctrl] and press [A]....that will select EVERY found cell
Click the [Close] button

Hold down [Ctrl] and press .....that's a shortcut to set Italics

Is that something you can work with?
******************
Regards,

Ron


"Michael Koerner" wrote in message
...
I have roughly 1200 records that I need to change (whatever is here)
including the brackets to italic Any way to do it with a quick macro or is
it going to be a one-at-a-time effort.

--

Regards
Michael Koerner