Excel help needed
#1
Scooby Regular
Thread Starter
Join Date: Oct 2004
Location: There is only one God - Elvis!
Posts: 8,328
Likes: 0
Received 0 Likes
on
0 Posts
Excel help needed
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!
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!
#3
Scooby Regular
Join Date: Sep 2006
Location: Worthing..
Posts: 7,575
Likes: 0
Received 0 Likes
on
0 Posts
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
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
#4
Scooby Regular
Thread Starter
Join Date: Oct 2004
Location: There is only one God - Elvis!
Posts: 8,328
Likes: 0
Received 0 Likes
on
0 Posts
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!!!!
#5
Moderator
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
The only way I can do that (Excel 2003) is:
What version of Excel is it?
- 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?
Thread
Thread Starter
Forum
Replies
Last Post
robbie1988
Wanted
2
13 September 2015 09:25 AM
Scooby-Doo 2
Wheels And Tyres For Sale
1
09 September 2015 06:51 PM