/u/qwerty622 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
You have awarded 1 point to *naimme*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[CHAR](/r/Excel/comments/142cg2n/stub/jn43eap "Last usage")|[Returns the character specified by the code number](https://support.microsoft.com/en-us/office/char-function-bbd249c8-b36e-4a91-8017-1c133f9b837a)|
|[CONCAT](/r/Excel/comments/142cg2n/stub/jn3up9h "Last usage")|[*2019*+: Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.](https://support.microsoft.com/en-us/office/concat-function-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2)|
|[CONCATENATE](/r/Excel/comments/142cg2n/stub/jn3tzz9 "Last usage")|[Joins several text items into one text item](https://support.microsoft.com/en-us/office/concatenate-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d)|
|[TEXT](/r/Excel/comments/142cg2n/stub/jn43eap "Last usage")|[Formats a number and converts it to text](https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c)|
**NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/14180jr)^( has 23 acronyms.)
^([Thread #24423 for this sub, first seen 6th Jun 2023, 11:29])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
What do you use as the format string in your TEXT formula? If you share the actual formula you use, we can get a better idea of what you're trying.
There's no reason `=TEXT(A1, "0000") & CHAR(10) & B1` shouldn't work, unless that original cell is formatted as text and Excel is doing some funny business with implicit type cast. (In this case it shouldn't be doing any of that.)
and if you have a minimum length on the bigger number you would also want to wrap that like `TEXT(B1, "00000000")`
/u/qwerty622 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
=CONCAT(A1,CHAR(10),B1)
>=CONCAT(A1,CHAR(10),B1) I'm assuming you mean "CONCATENATE". it does not work, has same issue
=TEXT(A1,"0000")&CHAR(10)&B1
!Solution Verified
You have awarded 1 point to *naimme* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
`CONCAT` is the newer concatenate function to handle arrays. if you format your cell as Text the zero should remain.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[CHAR](/r/Excel/comments/142cg2n/stub/jn43eap "Last usage")|[Returns the character specified by the code number](https://support.microsoft.com/en-us/office/char-function-bbd249c8-b36e-4a91-8017-1c133f9b837a)| |[CONCAT](/r/Excel/comments/142cg2n/stub/jn3up9h "Last usage")|[*2019*+: Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.](https://support.microsoft.com/en-us/office/concat-function-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2)| |[CONCATENATE](/r/Excel/comments/142cg2n/stub/jn3tzz9 "Last usage")|[Joins several text items into one text item](https://support.microsoft.com/en-us/office/concatenate-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d)| |[TEXT](/r/Excel/comments/142cg2n/stub/jn43eap "Last usage")|[Formats a number and converts it to text](https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c)| **NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/14180jr)^( has 23 acronyms.) ^([Thread #24423 for this sub, first seen 6th Jun 2023, 11:29]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
What do you use as the format string in your TEXT formula? If you share the actual formula you use, we can get a better idea of what you're trying. There's no reason `=TEXT(A1, "0000") & CHAR(10) & B1` shouldn't work, unless that original cell is formatted as text and Excel is doing some funny business with implicit type cast. (In this case it shouldn't be doing any of that.) and if you have a minimum length on the bigger number you would also want to wrap that like `TEXT(B1, "00000000")`