fbpx
Site logo white shadow

How to create large block of data

I was creating a video on data analytics today. I needed to show a graphic containig lots of data scrolling in the background for the video title. This is how I did it.

  • Create many rows of data by using this formula in Excel
    =RANDBETWEEN(1111111111111110,9999999999999990)
  • Copied the resulting data and pasted in Word as Text
  • Search for ^p which means paragraph mark and replace with nothing
  • This merged all the data into one big block of text
  • Paste it into a textbox in PowerPoint and use it for animation to create the title for the video

The result looks like this. Moral of the story? Use the right tool in the right place!

Large block of data as text

2 Responses

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,755 other subscribers

Popular articles

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.