Jump to content

Creating formulas in excel that use letters instead of numbers as inputs and outputs

AshesAndWool
By AshesAndWool
in Programs, Apps and Websites
 Share
Go to solution Solved by jj9987,

You don't add letters, you concatenate them, so use the CONCAT(text1, [text2],…) function.

Posted

Hey guys, really awkward formulation in the question because I am not really sure what the terminology is, but I can explain it perfectly with the problem I have:
I am making a huge spreadsheet that uses Letters as name for both the x and y axis, and I could name each cell manually but it would be way faster if excel could do this for me. Here are the images of what I am trying to do, and the abstract "formula" I want. Is there any way to make excel do this?
image.thumb.png.205e13ea12f3bb41d91f40280d0f35d2.png

I want it to take the numbers of the marked cells in the formula and spell out the letter in the cells after each other in a single word:
image.png.c58cdd801eeace877da19a6537d4842b.png

Sorry for the really clumsy explanation I have almost never used excel at anything more than a completely basic level before, hope someone can help me. Thanks for your time!

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
  • Solution

You don't add letters, you concatenate them, so use the CONCAT(text1, [text2],…) function.

HAL9000: AMD Ryzen 9 3900x | Noctua NH-D15 chromax.black | 32 GB Corsair Vengeance LPX DDR4 3200 MHz | Asus X570 Prime Pro | ASUS TUF 3080 Ti | 1 TB Samsung 970 Evo Plus + 1 TB Crucial MX500 + 6 TB WD RED | Corsair HX1000 | be quiet Pure Base 500DX | LG 34UM95 34" 3440x1440

Hydrogen server: Intel i3-10100 | Cryorig M9i | 64 GB Crucial Ballistix 3200MHz DDR4 | Gigabyte B560M-DS3H | 33 TB of storage | Fractal Design Define R5 | unRAID 6.9.2

Carbon server: Fujitsu PRIMERGY RX100 S7p | Xeon E3-1230 v2 | 16 GB DDR3 ECC | 60 GB Corsair SSD & 250 GB Samsung 850 Pro | Intel i340-T4 | ESXi 6.5.1

Big Mac cluster: 2x Raspberry Pi 2 Model B | 1x Raspberry Pi 3 Model B | 2x Raspberry Pi 3 Model B+

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
  • Author
3 minutes ago, Slottr said:

Believe you're looking for =CONCATENATE

You guys are such fucking heroes, I would have spent hours looking for that. Thank you so much!!

Link to comment
Share on other sites
Link to post
Share on other sites
Posted
  • Author
5 minutes ago, jj9987 said:

You don't add letters, you concatenate them, so use the CONCAT(text1, [text2],…) function.

You guys are such fucking heroes, I would have spent hours looking for that. Thank you so much!!

Link to comment
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programs, Apps and Websites

×