jo.stanley
Board Regular
- Joined
- Apr 13, 2004
- Messages
- 177
Im using Excel 2007 and have a speadsheet with 1000s of rows. 2 columns in each row continue text however I need this text to be in one column. I need to do this for every row. So for example
Column 1. text = hello my name i
Column 2. text = s Joanne
I need it in one column reading "hello my name is Joanne"
Is there any easy way of doing this for the whole sheet?
Column 1. text = hello my name i
Column 2. text = s Joanne
I need it in one column reading "hello my name is Joanne"
Is there any easy way of doing this for the whole sheet?
