already
Board Regular
- Joined
- Nov 11, 2008
- Messages
- 179
Hi
On a regular base I have to download text from the www.
The results are some columns in upper case and some columns in proper.
I have to merge those colums to 1 cell.
ex
A B C D E (required results)
LOTUS NOTES First Floor LOTUS NOTES First Floor
IBM Back Office IBM Back Office
HP Second Floor HP Second Floor
I have tried to do this with an IF formula using a combination of formulas as this
=IF(EXACT(J30;UPPER(J30));I30&" "&J30;"") but I run in to troubles.
Who can help me
Thanks in advance
Al
On a regular base I have to download text from the www.
The results are some columns in upper case and some columns in proper.
I have to merge those colums to 1 cell.
ex
A B C D E (required results)
LOTUS NOTES First Floor LOTUS NOTES First Floor
IBM Back Office IBM Back Office
HP Second Floor HP Second Floor
I have tried to do this with an IF formula using a combination of formulas as this
=IF(EXACT(J30;UPPER(J30));I30&" "&J30;"") but I run in to troubles.
Who can help me
Thanks in advance
Al