kshitij_dch
Active Member
- Joined
- Apr 1, 2012
- Messages
- 362
- Office Version
- 365
- 2016
- 2007
- Platform
- Windows
Hello all,
i am working on a file where i have data from A1 to Z1 ( Country name) and from A2 to Z2 ( Comments)
1st row has country name
2nd row has comments
i am looking to concatenate comments and country name , i am ok to do it with normal concatenate however i have few cells in comments which are blank
i want formula only to concatenate country name and comments where comments are present in cells , if cell is blank formula should skip blanks
i am ok with VBA code if possible
i am working on a file where i have data from A1 to Z1 ( Country name) and from A2 to Z2 ( Comments)
1st row has country name
2nd row has comments
i am looking to concatenate comments and country name , i am ok to do it with normal concatenate however i have few cells in comments which are blank
i want formula only to concatenate country name and comments where comments are present in cells , if cell is blank formula should skip blanks
i am ok with VBA code if possible