Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate with hyphens answer
I tried to reply to a Concatenate Formula question and it is unavailable so I
will post it this way your concatenate formula should read =CONCATENATE(A1," ","&"," ",B1). -- Taffy ~ Pulled in EVERY Direction & as SWEET as can be!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate with hyphens answer
CONCATENATE is a useless function. You can simply use the & operator instead. E.g., ="Hello"&" "&"World" For a VBA function that *vastly* improves upon CONCATENATE, see http://www.cpearson.com/excel/StringConcatenation.aspx Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 8 Aug 2009 11:27:01 -0700, Taffy wrote: I tried to reply to a Concatenate Formula question and it is unavailable so I will post it this way your concatenate formula should read =CONCATENATE(A1," ","&"," ",B1). |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate with hyphens answer
Hi Chip,
I don't think it is a useless function at all. I use it quite often to extract information. My post was meant for this question: Cell A1 = ##-#### Cel B1 = ##-@@@@. When I try to merge the two using =A1&" "&"B1 I get @@@@, the text string after the hyphen in the second cell. Why is it cutting off at the hyphen and what can I do to remedy this? What would your answer be? THX!! -- Taffy ~ Pulled in EVERY Direction & as SWEET as can be!! "Chip Pearson" wrote: CONCATENATE is a useless function. You can simply use the & operator instead. E.g., ="Hello"&" "&"World" For a VBA function that *vastly* improves upon CONCATENATE, see http://www.cpearson.com/excel/StringConcatenation.aspx Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 8 Aug 2009 11:27:01 -0700, Taffy wrote: I tried to reply to a Concatenate Formula question and it is unavailable so I will post it this way your concatenate formula should read =CONCATENATE(A1," ","&"," ",B1). |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate with hyphens answer
When I use =A1&B1 or =A1&""&B1 with the text string you describe, I
get the expect result of ##-#####-@@@@. My first guess would be that you have the "Transition Formula Evaluation" and/or "Transition Formula Entry" setting enabled. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 8 Aug 2009 23:47:01 -0700, Taffy wrote: Hi Chip, I don't think it is a useless function at all. I use it quite often to extract information. My post was meant for this question: Cell A1 = ##-#### Cel B1 = ##-@@@@. When I try to merge the two using =A1&" "&"B1 I get @@@@, the text string after the hyphen in the second cell. Why is it cutting off at the hyphen and what can I do to remedy this? What would your answer be? THX!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate with hyphens | Excel Worksheet Functions | |||
Calculator Answer Doesn't Match Excel Answer | Excel Discussion (Misc queries) | |||
Hard Hyphens | Excel Discussion (Misc queries) | |||
Using Hyphens in a cell | Excel Discussion (Misc queries) | |||
Does XL2K have "hard hyphens" (non-break hyphens)? | Excel Discussion (Misc queries) |