Adding - sign(-)
 

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

--
harvindersingh
-----------------------------------------------------------------------
harvindersingh1's Profile: http://www.excelforum.com/member.php...fo&userid=3172
View this thread: http://www.excelforum.com/showthread.php?threadid=52948

Adding - sign(-)
 

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.


Try this:

Data in column A, formula in column b.

aaaaa aa-aaa =IF(LEN(A2)<3,"",LEFT(A2,LEN(A2)-3)&"-" & RIGHT(A2,3))


HTH,

Ron

Adding - sign(-)
 

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