| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combining columns and using concatenate
Yes, that worked great. Thank you soooo much.
"Max" wrote: On the face of it, think you could try this Put in say, D2: =IF(A2="","",IF(B2<"",B2,A2)) Copy D2 down to return required results. Then copy col D and overwrite col A with a paste special as values. Clear col D. You're done in about 10-15 secs. Inspiring? hit the YES below -- Max Singapore --- I have 2 columns A and B. Many of the cells are blank in column B. When column B has information in it, I want it to replace the information in Col A with the information from Col B-if col B is blank, then keep the information from Col A |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONCATENATE TWO COLUMNS | Excel Worksheet Functions | |||
| Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
| combining two rows of data into one (Not Concatenate) | Excel Discussion (Misc queries) | |||
| Combining two formulas using concatenate | Excel Worksheet Functions | |||
| Concatenate two columns? | Excel Worksheet Functions | |||
![Donna[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
