Merging 2 cells

riothecat · #1 01-04-2017, 10:58 AM

I know I can merge 2 cells, I also know that by combining 2 cells it only keeps the info in the left most cell. is there a way to combine info in 2 different cells

A1 B1

AFG 1368

So that the numbers in a1 would combine (merge) with B1 and return a result of afg1368.

Thanks

gebobs · #2 01-04-2017, 02:24 PM

Try this in a third cell, like C1.

Code:

=a1&B1

riothecat · #3 01-04-2017, 02:36 PM

perfect. so simple is silly

gebobs · #4 01-04-2017, 03:00 PM

Haha...well that's how it goes sometimes.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formating all cells in an array based on adjacent cells	deejay	Excel	6	12-20-2016 12:00 PM
VBA merging cells and counting Merged rows	Snaybot	Excel Programming	2	11-09-2015 03:56 AM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM
Merging cells and keeping all the data/values	Holgate1967	Excel	1	11-29-2013 09:37 AM
Merging and Shading Cells based on Dates	stockers	Excel Programming	0	03-07-2013 02:32 PM