| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CONCATENATE not working
I have
F2 G2 H2 Zip Plus4 ZipPlus4 84116 3153 =CONCATENATE(F2,"-",G2) F2 and G2 are "Formated" to be text. Why is the H2 value =CONCATENATE(F2,"-",G2) and not 84116-3153? Thank you.. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CONCATENATE not working
works for me
try =F2 & "-" & G2 -- Gary "Bruce A. Julseth" wrote in message ... I have F2 G2 H2 Zip Plus4 ZipPlus4 84116 3153 =CONCATENATE(F2,"-",G2) F2 and G2 are "Formated" to be text. Why is the H2 value =CONCATENATE(F2,"-",G2) and not 84116-3153? Thank you.. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CONCATENATE not working
Hi Bruce
Probably beacause your cell in H2 is formated as text too. HTH Cordially Pascal "Bruce A. Julseth" a écrit dans le message de news: ... I have F2 G2 H2 Zip Plus4 ZipPlus4 84116 3153 =CONCATENATE(F2,"-",G2) F2 and G2 are "Formated" to be text. Why is the H2 value =CONCATENATE(F2,"-",G2) and not 84116-3153? Thank you.. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CONCATENATE not working
this works =F2&" - "&G2 "Bruce A. Julseth" wrote: I have F2 G2 H2 Zip Plus4 ZipPlus4 84116 3153 =CONCATENATE(F2,"-",G2) F2 and G2 are "Formated" to be text. Why is the H2 value =CONCATENATE(F2,"-",G2) and not 84116-3153? Thank you.. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CONCATENATE not working
Should work if text or number
-- Don Guillett SalesAid Software "Bruce A. Julseth" wrote in message ... I have F2 G2 H2 Zip Plus4 ZipPlus4 84116 3153 =CONCATENATE(F2,"-",G2) F2 and G2 are "Formated" to be text. Why is the H2 value =CONCATENATE(F2,"-",G2) and not 84116-3153? Thank you.. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CONCATENATE not working
Do a find and replace.
Find = Replace with = that will sort it. "Bruce A. Julseth" wrote: I have F2 G2 H2 Zip Plus4 ZipPlus4 84116 3153 =CONCATENATE(F2,"-",G2) F2 and G2 are "Formated" to be text. Why is the H2 value =CONCATENATE(F2,"-",G2) and not 84116-3153? Thank you.. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CONCATENATE not working
"PaulW" wrote in message ... Do a find and replace. Find = Replace with = that will sort it. "Bruce A. Julseth" wrote: I have F2 G2 H2 Zip Plus4 ZipPlus4 84116 3153 =CONCATENATE(F2,"-",G2) F2 and G2 are "Formated" to be text. Why is the H2 value =CONCATENATE(F2,"-",G2) and not 84116-3153? Thank you.. This worked, namely Find = and replace with =. Why? I reFormated H2 to be "General" and it now works. Why? Thank you.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate not working | Excel Discussion (Misc queries) | |||
| Concatenate in a Cell (&) and working with the numbers. | Excel Discussion (Misc queries) | |||
| Concatenate Formula not working | Excel Discussion (Misc queries) | |||
| Concatenate with Line Feed not working | Excel Discussion (Misc queries) | |||
| Concatenate function not working for me | Excel Discussion (Misc queries) | |||
Linear Mode
