| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| = sign in formula changes to + when adding a cell or name | Excel Discussion (Misc queries) | |||
| Automatic adding in a single cell w/o equal sign | Excel Worksheet Functions | |||
| Rounding to integers and adding plus sign | Excel Discussion (Misc queries) | |||
| how can i change dollar sign to rupee sign in sales invoice | Excel Discussion (Misc queries) | |||
| XL invoice replace the dollar sign with euro sign | New Users to Excel | |||
Hybrid Mode
