combining the contents 2 cells into the one cell merging data
Posted by Allen on March 19, 2001 8:56 PM
This there a way to take the contents of one cell and merge with another cell next to it, combining the contents into the one cell. example, one column has area codes, the next has the 7 digit number, can I combine these ( for 1500 rows ) ?? in to one column ???
Posted by Dave Hawley on March 19, 2001 9:20 PM
Hi Alan
You most certainly can!
Lets say your entries you want to combine are in Columns A & B. In C1 put: =A1&B1
Now double click the fill handle (or copy down as far as needed)
With Column C selected push Ctrl+C (copy),then go to Edit>Paste special-Vales
Dave
OzGrid Business Applications
Posted by Dave Hawley on March 19, 2001 9:23 PM
After Thought!
In case you want to keep them as a real number use: =Value(A1&B1)
...O if you want a space between them use:
=A1 & " " & B1
Dave
OzGrid Business Applications
Posted by Allen on March 20, 2001 5:44 AM
Thank You !@!!!@!
THANK YOU
