Value manipulation, String to Int, Int to Sting

Hi all..


1. How to delete "$" in string and convert to int, ie:
From:
String a = "$100"
Into:
Int b = 100

2. How to combine int and string become one string, ie:
From:
String a = "January";
Int b = 5;
Into:
String c = "5 January"; // Please add space in between.


Thank you..

Originally Posted by bluechip

Hi all..


1. How to delete "$" in string and convert to int, ie:
From:
String a = "$100"
Into:
Int b = 100

2. How to combine int and string become one string, ie:
From:
String a = "January";
Int b = 5;
Into:
String c = "5 January"; // Please add space in between.


Thank you..

Hi

not sure where you want to do this (in spreadsheet or in code) but look at

1) SUBSTITUTE: substitute(a,"$","")
2) c = 5 & " " & a
or
the CONCATENATE function
concatenate(b," ",a)

rylo