Joining 2 cells into new cell

  • Thread starter Thread starter PayeDoc
  • Start date Start date
P

PayeDoc

Hello all

I have a workbook with 5 worksheets All have the same row headings in row 1
and the same column headings in column A. Sheets 1 and 2 have calculated
values in most cells of rows 2-60 and columns B to T (the calculations
involve references to sheet 4 and 5), with the results typically having 4 or
more decimal places: but all the cells are formatted for 'currency' for
visual ease, although I need to retain all the decimal places for other
calculations. I need to get sheet 3 to show in each cell of rows 2-60 and
columns B to T the values of the corresponding cells in both sheet 2 and
sheet 3, separated by a hyphen.
e.g.
Sheet 1, B6 = 52.3256, formatted for display as £52.33
Sheet 2, B6 = 14252.47156, formatted for display as £14,252.47
I need Sheet 3, B6 to show £52.33 - £14,252.47

I am sure this can be done, but have tried all sorts and so far failed!

Hope someone can help.
Many thanks
Leslie Isaacs
 
This should do it for you:

="$" & ROUND(Sheet1!B6,2) & " - $" & ROUND(Sheet2!B6,2)

Replace my $ symbol with your currency symbol - guess who is too lazy to
look up the Alt/number :-)
 
Just realised, I missed the comma. Adding it this way is too complex. Use
Dave's formula.
 
Hello "AltaEgo"

Many thanks for your reply.
I have used Dave's formula, as you suggested!

Thanks again
Les
 
Back
Top