Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Chuck W
 
Posts: n/a
Default Concatenate Function will not work

Hi,

I am having trouble getting the concatenate function to
work. There are five columns of data I am trying to
combine which include Address1, Address2, City, State and
Zip. I have tried changing to formats from general to
text but they will not concatenate. Whenever I use the
function wizard, it simply says =concatenate
(a2,b2,c2,d2,d2) rather than combining my fields. Is
there setting I need to adjust?

Thanks,

Chuck
  #2   Report Post  
Michael
 
Posts: n/a
Default

Hi Chuck

Try this:

=A2&" "&B2&" "&C2&" "&D2
The inverted commas between each cell will give you a space between each
value

HTH
Michael

"Chuck W" wrote:

Hi,

I am having trouble getting the concatenate function to
work. There are five columns of data I am trying to
combine which include Address1, Address2, City, State and
Zip. I have tried changing to formats from general to
text but they will not concatenate. Whenever I use the
function wizard, it simply says =concatenate
(a2,b2,c2,d2,d2) rather than combining my fields. Is
there setting I need to adjust?

Thanks,

Chuck

  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

=A2&" "&B2&" "&C2&" "&D2&" "&E2

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Chuck W" wrote in message
...
Hi,

I am having trouble getting the concatenate function to
work. There are five columns of data I am trying to
combine which include Address1, Address2, City, State and
Zip. I have tried changing to formats from general to
text but they will not concatenate. Whenever I use the
function wizard, it simply says =concatenate
(a2,b2,c2,d2,d2) rather than combining my fields. Is
there setting I need to adjust?

Thanks,

Chuck



  #4   Report Post  
Nick Hodge
 
Posts: n/a
Default

Chuck

I suspect that whilst you have been changing the format to text, it has
stuck at that as the formula works for me. You could try deleting your
existing rows/columns or set it up on a new sheet and see if it works there.

You can also avoid the concatenate function with a simple

=A2&B2&C2....etc

I doubt this will make any difference though

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Chuck W" wrote in message
...
Hi,

I am having trouble getting the concatenate function to
work. There are five columns of data I am trying to
combine which include Address1, Address2, City, State and
Zip. I have tried changing to formats from general to
text but they will not concatenate. Whenever I use the
function wizard, it simply says =concatenate
(a2,b2,c2,d2,d2) rather than combining my fields. Is
there setting I need to adjust?

Thanks,

Chuck



  #5   Report Post  
Gord Dibben
 
Posts: n/a
Default

Chuck

You either have Formula View set to on or your cell with the formula is
formatted as text.

1. Hit CTRL + `(backquote above TAB key) to toggle view formulas off.

2. Format the formula cell as General then hit F2 then ENTER key.


Gord Dibben Excel MVP

On Mon, 31 Jan 2005 13:36:30 -0800, "Chuck W"
wrote:

Hi,

I am having trouble getting the concatenate function to
work. There are five columns of data I am trying to
combine which include Address1, Address2, City, State and
Zip. I have tried changing to formats from general to
text but they will not concatenate. Whenever I use the
function wizard, it simply says =concatenate
(a2,b2,c2,d2,d2) rather than combining my fields. Is
there setting I need to adjust?

Thanks,

Chuck


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trim function doesn't clean out ASCII Code 160 (Space) Ronald Dodge Excel Worksheet Functions 6 January 27th 05 04:48 AM
Using CONCATENATE function to create email addresses from a list Almamba Excel Worksheet Functions 2 January 23rd 05 10:10 PM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 01:25 AM
GCD Function doesn't work in some cases GCD_Dilemma Excel Worksheet Functions 5 November 8th 04 09:18 PM
How do I insert a line break when using the CONCATENATE function? ShaneRuth Excel Worksheet Functions 2 November 6th 04 12:26 AM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"