concatenate 2 different values

Answers
-
How can I concatenate 2 different values? The (+) or Join will not work in this case. Trying to concatenate 100 and 878 to be "100878".
-
You can use + to add together those two numbers, but also add in "" to have the numbers read as text (instead of as numbers). This will then link them together in order, instead of creating a SUM of the two values.
Ex:
=[First Value]@row + "" + [Second Value]@row
Keep in mind that this would create a string instead of a number, so then you wouldn't be able to SUM or AVG the output. If this won't work for you, it would be helpful to know a bit more about your process: what the two numbers are and why they need to be linked, then what the purpose of that linked value is.
Cheers!
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Try this ...
=SUBSTITUTE((<cell containing 100>+ "." + <cell containing 878>, ".", "")
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!