Copying part of a title (after a '-') to another cell

Hi,

I have a lot of titles like "A Company - Strategy A", "A Company - Strategy B" and what I am hoping to do is strip out the part after the hyphen to the cell directly above. This is the case across about 200 columns, I'd imagine this is pretty easy?

The attached spreadsheet makes it very clear.

Thanks,

Tim

Originally Posted by Special-K

In B2

=RIGHT(B3,FIND("-",B3)-1)

and copy where appropriate

Your sheet seems row based so it will require some manual copying across the row

How do I VBA that?

Thanks!

Originally Posted by Leith Ross

Hello shmee,

You can do this either by worksheet formula or VBA code. I don't Excel 2007, so I can't view your workbook. Personally, I would think that the formula approach is your best option. A VBA solution would probably be overkill, unless you really want a VBA solution.

It's one part of a very big VBA thing, so that is definitely the way I wish to do it, I'm just learning (and taking my time over it) to make the rest of my life easier!

Many thanks,

Tim

Attached old office version.

Thanks,

Tim

Originally Posted by Leith Ross

Hello shmee150,

Thanks for the 2003 version. I assume you will have more than single row of data, yes? If so, how would multiple rows be arranged?

Well I don't want this code to touch anything that's below Row 3, but row 3 extends for about 200 columns.

Thanks,

Tim

Hi,

Excellento, thank you very much for your time. I have one more question however, I actually have two sheets; one called "returns" and one called "output", the code automatically runs on the primary sheet, returns however I want it to happen on output. Is there a simple fix to do this? I've tried all sorts of things but am not getting very far.

It does however do exactly what I want albeit on the wrong sheet!!

Many thanks,

Tim