Home |
Search |
Today's Posts |
#1
|
|||
|
|||
concatenating numbers
Im trying to concatenate numbers across columns into a single cell without
any spaces between the numbers. Every time I try it I get a warning that a value in the formula is of the wrong type. I have tried converting the numbers into text format and still no luck. Help would be greatly appreciated. |
#2
|
|||
|
|||
Nig, how about something like this, =CONCATENATE(A1,B1,C1)
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mig" wrote in message ... I'm trying to concatenate numbers across columns into a single cell without any spaces between the numbers. Every time I try it I get a warning that a value in the formula is of the wrong type. I have tried converting the numbers into text format and still no luck. Help would be greatly appreciated. |
#3
|
|||
|
|||
Hi Mig,
It would faster for us to test if you gave examples of what we should be testing with.and their formatting. AND what you did, what you expected. You might make sure that calculation is turned on and that you formatting is in effect F2 then enter for each value if it changes then your formatting was done after entry. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Mig" wrote in message ... I'm trying to concatenate numbers across columns into a single cell without any spaces between the numbers. Every time I try it I get a warning that a value in the formula is of the wrong type. I have tried converting the numbers into text format and still no luck. Help would be greatly appreciated. |
#4
|
|||
|
|||
It sounds like maybe you might be trying to CONCATENATE using + signs
instead of & signs, and if one of the cells were TEXT, you would get the #VALUE! error............ Try either =A1&B1&C1 or =CONCATENATE(A1,B1,C1) If nothing works, get back to us with more info about what you tried and what results you got....... Vaya con Dios, Chuck, CABGx3 "Mig" wrote in message ... I'm trying to concatenate numbers across columns into a single cell without any spaces between the numbers. Every time I try it I get a warning that a value in the formula is of the wrong type. I have tried converting the numbers into text format and still no luck. Help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |