If your data is text, maybe something like
=IF(LEN(A1)<4,A1,LEFT(A1,LEN(A1)-3)&"-"&RIGHT(A1,3))

If your data is numeric, you could use a custom number format
#0-000

or
=TEXT(A1,"#0-000")

which converts the numeric data to text.

"harvindersingh1" wrote:


I have certain data in a particular column. Each cell having different
length data. Now i want to add (-) sign before 3 characters from right
side.
How would i do kindly help.


--
harvindersingh1
------------------------------------------------------------------------
harvindersingh1's Profile: http://www.excelforum.com/member.php...o&userid=31725
View this thread: http://www.excelforum.com/showthread...hreadid=529489