Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-28-2013, 08:04 PM
Holgate1967 Holgate1967 is offline Merging cells and keeping all the data/values Windows 8 Merging cells and keeping all the data/values Office 2013
Novice
Merging cells and keeping all the data/values
 
Join Date: Nov 2013
Posts: 1
Holgate1967 is on a distinguished road
Default Merging cells and keeping all the data/values

Hi, I have an exported data table that contains names and addresses. I need to have the address field "No, Street name, suburb, zip code, state" all in the one field. However this exported data table has these values in separate fields. How can I merge the fields and bring all the values into one single field.



thanks
Paul
Reply With Quote
  #2  
Old 11-29-2013, 09:37 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Merging cells and keeping all the data/values Windows 7 64bit Merging cells and keeping all the data/values Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

H
have a look at the CONCATENATE function or use the "&" to concatenate cell contents like =A1&B1&C1
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
merge data, mergefield address word

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Loss of formulae values when mail merging excel to word MellowMel Mail Merge 6 05-09-2014 09:08 AM
Merging cells and keeping all the data/values Merging excel values to text file daymaker Excel 18 10-24-2013 12:45 AM
Merging and Shading Cells based on Dates stockers Excel Programming 0 03-07-2013 02:32 PM
Merging cells and keeping all the data/values Merging three columns of data jdjette Excel 7 03-02-2012 04:48 PM
Change values in cells based on criteria SaneMan Excel Programming 2 02-02-2012 07:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft