Forum Discussion
Need text formula
Hi! Lets get a certain example from my data sheet. So i got this bank statement (obviously, for safety reasons data were changed) as .CSV file and i need to import those bold data into another sheet....
I'm finding it very difficult to believe that what you get as a bank statement resembles what you've shown.
I download bank statements as CSV files all the time... they're much more clear than what you're showing. And, they are "comma separated," that being what the C and S stand for.
So could you attach an actual CSV file, after first rendering the confidential parts into false, but still comparable, data elements? I.e., change text of company names to fictitious names, but still intelligible text, numbers of values to different values, but still values. etc.