Skip to Content
0
Former Member
Jul 02, 2012 at 02:22 PM

Data Formatting using Formula column

15 Views

I have three requirements

1) I need to print the Telephone Area code. I should read the phone number till the fist "Space" in the digits
EX: 0049 12324555 Output: 0049
091 12324344 Output: 091

2) How to print Multi line text as a single line text.
Ex: A1
A2
A3

Output: A1,A2,A3

3) How to print single line text as a Multi line text

Ex: A1,A2,A3

Output: A1
A2
A3