Ok might be an easy fix for the experts out there but for a dumb shmuck like me.... anyway i consider myself fairly competatnt with Excel but this is bugging me.

On a collegues PC at work she needs to take a number of addresses that are spread over 5 rows and paste it all into a single cell, for some strange reason on my PC i can do it but hers it just wont do it. I've tried pasting it into the text bar at the top and looked at formatting the cells to no avail.

Would like to sort this if i can because the lad who does the IT is bloody useless tbh

Thanks chaps!

 

Personally I'd just concatenate the five values into a new cell, then copy and paste values into your single cell.

=CONCATENATE(A1," ",A2," ",A3," ",A4," ",A5)

 

Select the cell you want the combined text to appear.

type =(

Then select the first cell of the text

Then type &" "& (assuming you want a space between the text) Then select the next cell

Then type &" "& and select the next cell and so on

Close the forumat with )

So it will look something like this

=(A5&" "&B5& " "&C5& " "&D5&" "&E5)


Thats the way I would do it. Am sure someone has a better way

 

The thing is on my PC i literally just double click on a cell and paste it in job done but i'm at a loss to why i can do it on mine yet she cannot on hers!!!!

 

The only way I can do that (Excel 2003) is:

• Select the 5 cells and copy
• Select the cell to paste into and edit it (cursor flashing inside)
• Click the copied data from the Office Clipboard

What version of Excel is it?

 

I'm not sure but i asked thre same question - maybe mine is a newer version