I looked through the search and could not find excatly whatI was looking for here.
What I am trying to do is merge data from 2 different cells into one cell. I have tried to use the merge cell command in excel but it drops the data from the second cell or cells. Kind of defeats the purpose.
I tried to record a macro to do this but it uses the specific cell data, and my prblem is each cell has different data that I want to merge. I know it can be done this way, just need to use the right variables. Anyone out there have the code out there for this. Any help would be much appreciated.
What I am trying to do is merge data from 2 different cells into one cell. I have tried to use the merge cell command in excel but it drops the data from the second cell or cells. Kind of defeats the purpose.
I tried to record a macro to do this but it uses the specific cell data, and my prblem is each cell has different data that I want to merge. I know it can be done this way, just need to use the right variables. Anyone out there have the code out there for this. Any help would be much appreciated.