USE A Function to retrieve text on different lines in cell

Hi guys

I have an export to csv from SQL which is showing text in multiple rows like this in each cell:


=---
- spam

Is there any formula someone can tell me where I 'trim' or reduce the first line and only have the value "- spam" returned?

Thanks!

P.s file attached - you might need to drag the formula bar down

Your file that you attached does not contain any examples of what you describe in your post. Suggest you post a sample that is a true representation of your issue.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Originally Posted by alansidman

Your file that you attached does not contain any examples of what you describe in your post. Suggest you post a sample that is a true representation of your issue.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi Alan,

Hi

Please see attached the same file

As mentioned this output has been taken from SQL and exported to a CSV file.

However, I am struggling with the fact I have to expand the 'formula bar' to read the text in cell A2.

As you can see (if you expand the formula bar) there are two lines:

=--- (on line 1)
- spam (on line 2)

I want to use a function like trim/left or whatever to retrieve the text from line 2.

Can you advise please?

When you open this CSV in excel you've got data in cols A-D, right.
So put into E2:

Formula:

Please Login or Register  to view this content.

and drag it down.

if you want to replace values in column A you have to use VBA.

Originally Posted by KOKOSEK

When you open this CSV in excel you've got data in cols A-D, right.
So put into E2:

Formula:

Please Login or Register  to view this content.

and drag it down.

if you want to replace values in column A you have to use VBA.

Awesome it works!

You welcome.
Thanks for Rep.