Hi,
I could really use some help.
I have a spreadsheet with 2 different worksheets : 'MS' and 'BSM'
The MS has values inputted manually and the BSM has the function " = MS!cell#" in specific cells to transfer those values.
simple so far.
The problem?
I want to merge some cells values in BSM but I cannot do it
For example, the MS worksheet has individual values in cells B7 & B8 , ie 1& 40, or 2 & 20, etc. I want this put as "1x40" or "2x20" in one cell in the BSM spreadsheet.
So, in other words, merge the values, but separate them by a "x" value
The other merge involves cities. The MS worksheet has 2 cells in which each has a city name such as New York in B36 and another city,ie Port Klang, in B37. I want is simply copy this as "New York/Port Klang" in one cell in BSM.
Can anybody help ????????
Thanks
Al
I could really use some help.
I have a spreadsheet with 2 different worksheets : 'MS' and 'BSM'
The MS has values inputted manually and the BSM has the function " = MS!cell#" in specific cells to transfer those values.
simple so far.
The problem?
I want to merge some cells values in BSM but I cannot do it
For example, the MS worksheet has individual values in cells B7 & B8 , ie 1& 40, or 2 & 20, etc. I want this put as "1x40" or "2x20" in one cell in the BSM spreadsheet.
So, in other words, merge the values, but separate them by a "x" value
The other merge involves cities. The MS worksheet has 2 cells in which each has a city name such as New York in B36 and another city,ie Port Klang, in B37. I want is simply copy this as "New York/Port Klang" in one cell in BSM.
Can anybody help ????????
Thanks
Al