unable to sum/ calculate copied data from ERP or mail

=CHAR(160) When you use this function in a cell, it will return a non-breaking space, which is a special type of space that is used to prevent a line break at that point in the text. This can be useful for formatting cells that contain long text strings or for aligning text in a specific way. You can use this function in a formula or directly in the cell. It's also important to note that you can use the ALT + 0160 to insert the non-breaking space in the cell.

Comments

Excel automation App

EXCEL AUTOMATION APP by Ramesh Aitha

Get multiple lookup values in single cell

Rupees into words

Option Explicit Function RupeesInWords(ByVal MyNumber As Double) As String Dim Rupees As String Dim Paise As String Dim Temp As String Dim DecimalPlace As Integer MyNumber = Round(MyNumber, 2) DecimalPlace = InStr(MyNumber, ".") If DecimalPlace > 0 Then Rupees = Left(MyNumber, DecimalPlace - 1) Paise = Mid(MyNumber, DecimalPlace + 1) Else Rupees = MyNumber Paise = "" End If RupeesInWords = "" If Val(Rupees) > 0 Then RupeesInWords = ConvertToWords(Rupees) & " Rupees" End If If Val(Paise) > 0 Then RupeesInWords = RupeesInWords & " and " & ConvertTwoDigits(Left(Paise & "00", 2)) & " Paise" End If RupeesInWords = Application.WorksheetFunction.Trim(RupeesInWords) & " Only" End Function Private Function ConvertToWords(ByVa...

JA EXCEL

Search This Blog