| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
CONCATENATE problem with blank cells
I need to merge columns A and B, but some cells are blank, so I can't copy the formula down the 3rd column...it stops at the 1st blank a1 Frank Smith a2 blank a3 blank a4 Bill Jones b2 blank b2 sally b3 billie b4 blank HELP? -- roger_home ------------------------------------------------------------------------ roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434 View this thread: http://www.excelforum.com/showthread...hreadid=396618 |
|
#2
|
|||
|
|||
|
Hi Roger,
You could Concatenate the Cells in Columns "A" & "B" Using the Following Formula Entered into Cell "C1" and Copying Down :- =CONCATENATE(A1,B1) OR =A1&B1 Hope this Helps. All the Best. Paul roger_home wrote: I need to merge columns A and B, but some cells are blank, so I can't copy the formula down the 3rd column...it stops at the 1st blank a1 Frank Smith a2 blank a3 blank a4 Bill Jones b2 blank b2 sally b3 billie b4 blank HELP? -- roger_home ------------------------------------------------------------------------ roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434 View this thread: http://www.excelforum.com/showthread...hreadid=396618 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic coloring of blank cells when sheet work complete | Excel Worksheet Functions | |||
| auto color blank cells ,best solution | Excel Discussion (Misc queries) | |||
| removing blank cells from a column | Excel Discussion (Misc queries) | |||
| Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
| count non blank cells which meet criteria in another column | Excel Worksheet Functions | |||
Linear Mode
