MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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