Greetings,
I have a spreadsheet where data in a cell contains carriage return at random places. I used split & char(10) to remove carriage return & bring the data as a unique text in separate cells of a row.
The contents of the orignial data with carriage return are such that, my first row may have Caller > Name > "Actual Name" > Caller > Phone > "actual Number" > Caller > Email > "Actual Email address" ........etc
The second row may have Caller > Name > "Actual Name" > Caller > Email > "Actual Email address" ........etc
Thus I have no guarrantee that there is a single column for phone number or email... etc
Now I have created a seperate sheet within the same workbook, in which I want to put one sigle column for name, one single columkn for phone, one single coumn for email for each record.
I intend to use if statement in such a manner that If any cellof a row in worksheet 1 contains the word "name" then copy the cell with adjacent cell in worksheet 2 specified cell; If If any cellof a row in worksheet 1 contains the word "no" then copy the cell with adjacent cell in worksheet 2 specified cell; If If any cellof a row in worksheet 1 contains the word "email" then copy the cell with adjacent cell in worksheet 2 specified cell.....etc
How to acheive this?
Regards
I have a spreadsheet where data in a cell contains carriage return at random places. I used split & char(10) to remove carriage return & bring the data as a unique text in separate cells of a row.
The contents of the orignial data with carriage return are such that, my first row may have Caller > Name > "Actual Name" > Caller > Phone > "actual Number" > Caller > Email > "Actual Email address" ........etc
The second row may have Caller > Name > "Actual Name" > Caller > Email > "Actual Email address" ........etc
Thus I have no guarrantee that there is a single column for phone number or email... etc
Now I have created a seperate sheet within the same workbook, in which I want to put one sigle column for name, one single columkn for phone, one single coumn for email for each record.
I intend to use if statement in such a manner that If any cellof a row in worksheet 1 contains the word "name" then copy the cell with adjacent cell in worksheet 2 specified cell; If If any cellof a row in worksheet 1 contains the word "no" then copy the cell with adjacent cell in worksheet 2 specified cell; If If any cellof a row in worksheet 1 contains the word "email" then copy the cell with adjacent cell in worksheet 2 specified cell.....etc
How to acheive this?
Regards
Last edited:
