Excel Help
08 August 2002, 03:12 PM
#1
Scooby Regular
Thread Starter
Join Date: Nov 2000
Location: Glasgow
Posts: 1,432
Likes: 0
Received 0 Likes
on
0 Posts
I have three columns in an Excel spreadsheet Title, FirstName and Surname. Is it possible to merge the three columns together and keep the data.
Cheers
Jer
Cheers
Jer
08 August 2002, 03:39 PM
#3
Moderator
iTrader: (5)
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes
on
0 Posts
Yes, you can use the concatenate formula:
eg. =CONCATENATE(A1,B1,C1)
Just put the formula in column D.
I normally insert additional columns between the columns I want to merge, fill them with a single space then merge all of the columns together. This will seperate the words with a space. You can then copy and paste values to get the data merged.
HTH
[Edited by DJ Dunk - 8/8/2002 3:41:55 PM]
eg. =CONCATENATE(A1,B1,C1)
Just put the formula in column D.
I normally insert additional columns between the columns I want to merge, fill them with a single space then merge all of the columns together. This will seperate the words with a space. You can then copy and paste values to get the data merged.
HTH
[Edited by DJ Dunk - 8/8/2002 3:41:55 PM]
Trending Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
bluebullet29
General Technical
9
05 October 2015 02:17 PM