Spreadsheet help

[Macky]

I have a column in a spread sheet that has alphanumeric data, with the first four characters in every cell made up of letters, followed by a string of numbers, no spaces between any characters.

Is there a handy way for me to remove the letters from each cell, just leaving the numbers there?

 

[Melton Fox]

Why don't you just pay somebody to do it you ****ing bully :icon_wink

 

[Steven]

I have a column in a spread sheet that has alphanumeric data, with the first four characters in every cell made up of letters, followed by a string of numbers, no spaces between any characters.

Is there a handy way for me to remove the letters from each cell, just leaving the numbers there?

More hatemongering. :icon_sad: What have you got against letters. :icon_conf :icon_conf :icon_conf

 

[Macky]

:icon_lol: :icon_lol:

If I don't find a way to do it I'll have to coerce an illegal immigrant to do it for me.

 

[Jeff]

I have a column in a spread sheet that has alphanumeric data, with the first four characters in every cell made up of letters, followed by a string of numbers, no spaces between any characters.

Is there a handy way for me to remove the letters from each cell, just leaving the numbers there?

Assuming you're using Excel, there are several ways of doing this, but the easiest way is to highlight the column, click on Data, Text to columns, Fixed width, and then select 'do not import' for the first four characters.

 

[Macky]

Assuming you're using Excel, there are several ways of doing this, but the easiest way is to highlight the column, click on Data, Text to columns, Fixed width, and then select 'do not import' for the first four characters.

I may need to do it on more than 1 PC so will be using either Excel or Open Office.

Thanks for that Jeff, I'll give it a lash tomorrow.

 

[Steven]

:icon_lol: :icon_lol:

If I don't find a way to do it I'll have to coerce an illegal immigrant to do it for me.

:icon_lol: :icon_lol: :icon_lol:

 

[SJN-Fox]

Assuming the cells are in col A then -

=RIGHT(A1, LEN(A1)-4)

 

[Macky]

Assuming the cells are in col A then -

=RIGHT(A1, LEN(A1)-4)

On the ball SJN, that looks like it could be just what I need.

 

[Melton Fox]

I'm gonna go and find a small person wearing glasses and kick his head in and steal his bus fare

Bully

 

[Macky]

Bully

:icon_lol:

I would only need to look as far as the mirror to find a bespectacled midget.

 

[SJN-Fox]

On the ball SJN, that looks like it could be just what I need.

My pleasure

 

[MKFox]

Assuming the cells are in col A then -

=RIGHT(A1, LEN(A1)-4)

Stop trying to win favour in here, after sullying the jug thread....

 

[SJN-Fox]

Stop trying to win favour in here, after sullying the jug thread....

I'll make up for that I promise. :icon_cry:

 

[MKFox]

I'll make up for that I promise. :icon_cry:

:icon_bigg

 

[Matt_B]

Also is there no way to do a RegEx replace in Excel, would be a simple enough regex, something like [0-9]*

 

[Darth Vodka]

oh an excel thread i missed

 

[Macky]

Thanks for all of your helpful suggestions lads, I decided to go with Melton's in the end & delegated it to somebody else.



Not an illegal immigrant, by the way, he's more of a hippy type from Kilkenny and I didn't have to bully him into it, but he will get a few slaps with a stick if he makes a balls of it.