Football scores in Excel

[sohum]

He can paste the scores into notepad and add a `'` before every row as well.

 

[ZexyZahid]

I've got 8 columns with 384 rows. Which means I've got to insert 3072 times before every score. And there are 4 worksheets, which means I've got to type ' 12288 times. Not very efficient.

But like I said: I already got the solution and that's the best one.

 

[SciD]

You do not need to go through all that macro and stuff.

Just select the column where you are pasting score and format it to be Text. Paste the value from notepad or website. Wolla.

 

[sohum]

I've got 8 columns with 384 rows. Which means I've got to insert 3072 times before every score. And there are 4 worksheets, which means I've got to type ' 12288 times. Not very efficient.

But like I said: I already got the solution and that's the best one.

A simple regex search and replace means you have to type about 4 characters and press one button. Much simpler than a macro.

sohum added 3 Minutes and 2 Seconds later...

Here's what you would use, btw:

Pattern: ([0-9]+-[0-9]+)
Replacement: '$1

 

[ZexyZahid]

I've been looking on the internet for about 25 minutes what you're saying. I found out that Regex is short word for Regular Expressions.

I thought I had to include these sentences in a function of Excel, but I couldn't find the function.

I am using Excel 2003 and the most of the references that I find were referred to Open Office software.

ZexyZahid added 3 Minutes and 1 Seconds later...

You do not need to go through all that macro and stuff.

Just select the column where you are pasting score and format it to be Text. Paste the value from notepad or website. Wolla.

I already tried that. Excel 2003 changes to a different number. For example '1-feb' changes into '40210'.

 

[Chewie]

So you can't format the cells before you paste it? Or is that when that happens?

 

[ZexyZahid]

I can change the cell properties to text, but when I paste the scores some cells automatically changes to dates.

But never mind. I already found that macro solution.