If statement + & operator +Count/Character formula help

[igmike]

Hi,

I am looking for a formula to combine text, one cell would add text DLC if present, no text if Game is present (B2). Max Count 80 characters, by picking the different choices of text (C2) that would not trim E2. It is beyond my skill set, I only know how to use necessary formulas individually.

A2= Text B2=Game or DLC C2=text with different # of characters D2=Text

C2= Region Free PC Key or Region Free Global PC Key
E2=A3&C3&" "&D3

Thanks in advance.

 

[DanteAmor]

Hi @igmike
Im sorry, but I don't understand your examples.
Could you put more examples of what you have in the cells and the result you want.

To do this, use the XL2BB tool. For example:

varios 27may2023.xlsm
	A	B	C	D	E
1					Expected result
2	Example1	Ex1 col B	Ex1 col C	Ex1 col D	?
3	Example2	Ex2 col B	Ex2 col C	Ex2 col D	?
4	Example3	Ex3 col B	Ex3 col C	Ex3 col D	?
5	Example4	Ex4 col B	Ex4 col C	Ex4 col D	?
Examples

Note XL2BB:
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in
Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[awoohaw]

An example of your data and scenarios would have been very helpful.
Here is a solution based on my interpretation of your question:

Book1
	A	B	C	D	E
1
2	Text	if "Game", "","DLC"	text w different nbr of chars	some more text	Text DLC text w different nbr of chars some more text
3	=A2	"DLC" or ""	=C2	=D2	=A2 DLC =C2 =D2
4	Blah	DLC	Blah Blah	Blah	Blah DLC Blah Blah Blah
igmike

Cell Formulas
Range	Formula
E2:E4	E2	=A2 &" "& IF(B2="Game","","DLC") &" "& C2 &" "& D2

Note: You need to give the priority of which cells must be reduced if the total length is greater than 80.

 

[igmike]

@DanteAmor @awoohaw

Thanks for your input. Had trouble getting Excel to accept XLBB2.0, So I've added images. If any other info is need, please let me know. Thanks. A simpler version I used this formula =A2&IF(LEN(A2)<66," Fast Delivery","")

Priority 1. Game Name, DLC if present, + platform cannot be altered
. Based on # of Characters in D2,
IF D2=<23>50,(Region Free GLOBAL PC Key) IF D2=<51>78 (Region Free PC)

Order of Cells for Title: A2 + DLC or " " + E2 + F2.

A= Game Name B=DLC or " "
A2:5 B2:4 = " "
Grand Theft Auto V: Premium Online Edition
Red Dead Redemption 2 Standard Edition
Human: Fall Flat
FIFA 20: 2200 FUT Points B5= DLC

C= Game + Platform D=Len function
C2:C4 =A2&B2&F2, C5=A5&B5&" "&F5
Grand Theft Auto V: Premium Online Edition Rockstar 52
Red Dead Redemption 2 Standard Edition Rockstar 48
Human: Fall Flat Steam 23
FIFA 20: 2200 FUT Points DLC Origin 36

 

[awoohaw]

try to get xl2bb to work. If it it isn't a work computer that has restrictions it will work. Mr. excel even has a testing area to test (link also below)

We cannot copy and paste data from images.
In the worst case, paste your data as a table.