# How to Add symbol In Before Last Number ( With Cell Reference / Without Cell Reference)

[krunal123]

# Without Cell Reference : " Check This image "

# With Cell Reference :

A1 = MSCU1234560 i try Cell Reference G1 =+A1 ( with use formula like right / Left )

 

[Zot]

I don't understand what exactly your question. You want something like this?

13-04-2021.xlsm
	A	B
1
2
3	MSCU1234560	MSCU123456-0
Main

Cell Formulas
Range	Formula
B3	B3	=LEFT(A3,LEN(A3)-1) & "-" & RIGHT(A3,1)

 

[navic]

# With Cell Reference :
A1 = MSCU1234560 i try Cell Reference G1 =+A1 ( with use formula like right / Left )

Try (in the G1 cell put a symbol)

=LEFT(A3,LEN(A3)-1) & $G$1 & RIGHT(A3,1)

 

[Zot]

Like this?

13-04-2021.xlsm
	A	B	C	D	E	F	G
1							-
2
3	MSCU1234560	MSCU123456-0
Main

Cell Formulas
Range	Formula
B3	B3	=LEFT(A3,LEN(A3)-1) & G1 & RIGHT(A3,1)

 

[Peter_SSs]

.. or one of these?

21 04 13.xlsm
	A	B	C	D	E	F	G
1							-
2
3	MSCU1234560	MSCU123456-0	MSCU123456-0
Insert symbol

Cell Formulas
Range	Formula
B3	B3	=REPLACE(A3,LEN(A3),0,"-")
C3	C3	=REPLACE(A3,LEN(A3),0,G1)