adding suffix to formula (in bulk)

**travo420** · 05-22-2013, 08:29 PM

Hi

have a table of data (hours worked), broken up into different days, shifts, and tasks on one sheet, and in a subsequest sheet (exact same layout) need to multiple each of the cells by the hourly rate.

is there a way to add a suffice of eg. *25 to, so that one sheet has hours work and the other has the total labour cost.

i tried the Concantenate formula but didnt seem to work i.e =CONCATENATE(,"*25,Scorecard!C5")

**vlady** · 05-22-2013, 08:34 PM

maybe a sample file could elaborate your issue so member's could understand more.

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**travo420** · 05-22-2013, 08:49 PM

I got, rather than try and add the suffix to each of the cells/formula i.e =Scorecard!c5*25, i added the 25 to a blank cell and then used that i.e =scorecard!c5*$b$37 (b37 has the figure of $25.00 in it), and then copied the formula accross the whole sheet.

I have just started a new role where i have to use excel quite a bit so I will most likely be back to ask and answer tricky questions about the untameable beast that excel can be...