Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to merge info
My spreadsheet has two description columns. I want to merge column B & C
together without loosing any data. If I merge B & C together, I loose the data in C. Is there any quick way to get this data to merge without typing each cell? B C PLATE 3/16 CLEAR 36X36 PLATE 3/16 CLEAR 36X38 Desired result: B PLATE 3/16 CLEAR 36X36 Thanks GRK |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to merge info
In D1 enter the following
=B1&" "&C1 Drag it down as far as needed. Then copy the column and paste special Values in column B. Delete column D Does that work? "GRK" wrote in message ... My spreadsheet has two description columns. I want to merge column B & C together without loosing any data. If I merge B & C together, I loose the data in C. Is there any quick way to get this data to merge without typing each cell? B C PLATE 3/16 CLEAR 36X36 PLATE 3/16 CLEAR 36X38 Desired result: B PLATE 3/16 CLEAR 36X36 Thanks GRK |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to merge info
Gaurav,
The info you provided is great and will eliminate many hours of data input. One more question. In following your advice, the results are that the two cells merged, but I need a space between the two cells. This is how the info is merging together. PLATE 3/16 CLEAR36X36 Notice there is no space between the word CLEAR and 36X36 How do I get the space between the two cells? Thanks -- GRK "Gaurav" wrote: In D1 enter the following =B1&" "&C1 Drag it down as far as needed. Then copy the column and paste special Values in column B. Delete column D Does that work? "GRK" wrote in message ... My spreadsheet has two description columns. I want to merge column B & C together without loosing any data. If I merge B & C together, I loose the data in C. Is there any quick way to get this data to merge without typing each cell? B C PLATE 3/16 CLEAR 36X36 PLATE 3/16 CLEAR 36X38 Desired result: B PLATE 3/16 CLEAR 36X36 Thanks GRK |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to merge info
It should be adding a space between 2 cells. If you look at the formula, it
says B1&" "&D1. there is a space between the " and ". if you are typing the formula yourself make sure to have space there. "GRK" wrote in message ... Gaurav, The info you provided is great and will eliminate many hours of data input. One more question. In following your advice, the results are that the two cells merged, but I need a space between the two cells. This is how the info is merging together. PLATE 3/16 CLEAR36X36 Notice there is no space between the word CLEAR and 36X36 How do I get the space between the two cells? Thanks -- GRK "Gaurav" wrote: In D1 enter the following =B1&" "&C1 Drag it down as far as needed. Then copy the column and paste special Values in column B. Delete column D Does that work? "GRK" wrote in message ... My spreadsheet has two description columns. I want to merge column B & C together without loosing any data. If I merge B & C together, I loose the data in C. Is there any quick way to get this data to merge without typing each cell? B C PLATE 3/16 CLEAR 36X36 PLATE 3/16 CLEAR 36X38 Desired result: B PLATE 3/16 CLEAR 36X36 Thanks GRK |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to merge info
Thanks, it worked.
-- GRK "Gaurav" wrote: It should be adding a space between 2 cells. If you look at the formula, it says B1&" "&D1. there is a space between the " and ". if you are typing the formula yourself make sure to have space there. "GRK" wrote in message ... Gaurav, The info you provided is great and will eliminate many hours of data input. One more question. In following your advice, the results are that the two cells merged, but I need a space between the two cells. This is how the info is merging together. PLATE 3/16 CLEAR36X36 Notice there is no space between the word CLEAR and 36X36 How do I get the space between the two cells? Thanks -- GRK "Gaurav" wrote: In D1 enter the following =B1&" "&C1 Drag it down as far as needed. Then copy the column and paste special Values in column B. Delete column D Does that work? "GRK" wrote in message ... My spreadsheet has two description columns. I want to merge column B & C together without loosing any data. If I merge B & C together, I loose the data in C. Is there any quick way to get this data to merge without typing each cell? B C PLATE 3/16 CLEAR 36X36 PLATE 3/16 CLEAR 36X38 Desired result: B PLATE 3/16 CLEAR 36X36 Thanks GRK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MERGE LIST INFO | Excel Worksheet Functions | |||
Mail merge with header/field info in 3rd row | Excel Discussion (Misc queries) | |||
merge 2 spreadsheets info to 1 | Excel Worksheet Functions | |||
How do I merge 2 excel spreadsheets containing some common info? | Excel Worksheet Functions | |||
I need to merge lots of info, w/o copy paste? | Excel Worksheet Functions |