HOW TO USE REFERENCE WITH "RIGHT OR LEFT" FORMULA FUNCTION ???? (=+A2 According This)

[krunal123]

HOW TO USE REFERENCE WITH "RIGHT OR LEFT" FORMULA FUNCTION ????


EXAMPLE: i Try this Reference "AB156480"

=+A2

But I need Output : " AB156-480"

How it Possible After reference ????

 

[arthurbr]

Where does the "-1" from you example come from?

 

[krunal123]

How to use "Right" Using The Refrence

 

[MARK858]

I am not sure where the -480 is coming from (the same as @arthurbr asked with the -1) but do you mean something like the below?

Book2
	A	B	C	D	E
1	Airline
2	Air New Zealand		Air New Zealand-480	480	Air New Zealand-480
3	Qantas			438	Qantas-438
4	Singapore Airlines			402	Singapore Airlines-402
5	Virgin Australia			376	Virgin Australia-376
6	Virgin Atlantic			285	Virgin Atlantic-285
7	Etihad Airways			442	Etihad Airways-442
8	All Nippon Airways			364	All Nippon Airways-364
9	Korean Air			373	Korean Air-373
10	Cathay Pacific			423	Cathay Pacific-423
11	Japan Airlines			422	Japan Airlines-422
Sheet3

Cell Formulas
Range	Formula
C2	C2	=A2 & "-480"
E2:E11	E2	=A2& "-" & D2

 

[arthurbr]

How to use "Right" Using The Refrence

That does not really help...