richardsmith1982
New Member
- Joined
- Mar 15, 2018
- Messages
- 1
Hi all,
I've tried searching lots of places for help on this, but cannot find what I need....
I've been given the most unhelpful file and need to try to decipher it to create useful reports.
I have lots of data in a single cell, and lots of other cells on the same row contain a similar story.
I think my aim is to make a new sheet and use this main page as an overview, with the contents of each cell having their own sheet.
I'm looking for a way to find the first instance of a number and display all consecutive numbers; a way to find the second instance of a number and display all consecutive numbers, etc. I have seen how to find the nth value, but I need all consecutive numbers to count as one instance. Some of the consecutive numbers are single digits, others are five digits.
I think at this point I may even take just using a newline as a cell break (copy and paste but the paste puts the single cell in to five according to the number of linebreaks)
Here is the contents of a single cell:
MAILCHIMP: 502 subscribersGOOGLE DOCS: 502 plus those who have unsubscribed but havent't yet been removed from google doc.
**Source of google doc info: webiste enquiries
BRUSHFIRE: 22
EMAIL:200-250 all data from formstack, email enquiries. All info still on work laptop. All sitting in a follow up folder on lap top.
FORMSTACK: 150
Has anyone experienced this before (and held back from throwing their boss out the window)?
Can anyone help?
Thanks!
I've tried searching lots of places for help on this, but cannot find what I need....
I've been given the most unhelpful file and need to try to decipher it to create useful reports.
I have lots of data in a single cell, and lots of other cells on the same row contain a similar story.
I think my aim is to make a new sheet and use this main page as an overview, with the contents of each cell having their own sheet.
I'm looking for a way to find the first instance of a number and display all consecutive numbers; a way to find the second instance of a number and display all consecutive numbers, etc. I have seen how to find the nth value, but I need all consecutive numbers to count as one instance. Some of the consecutive numbers are single digits, others are five digits.
I think at this point I may even take just using a newline as a cell break (copy and paste but the paste puts the single cell in to five according to the number of linebreaks)
Here is the contents of a single cell:
MAILCHIMP: 502 subscribersGOOGLE DOCS: 502 plus those who have unsubscribed but havent't yet been removed from google doc.
**Source of google doc info: webiste enquiries
BRUSHFIRE: 22
EMAIL:200-250 all data from formstack, email enquiries. All info still on work laptop. All sitting in a follow up folder on lap top.
FORMSTACK: 150
Has anyone experienced this before (and held back from throwing their boss out the window)?
Can anyone help?
Thanks!