Juxtaposing a column of numbers

**GonzoMoon** · 09-03-2009, 03:44 PM

Hi,
I have a row of numbers that need juxtaposed.
For example: if the number appears as 0051-72
I need to change it to 72-0051

The numbers all start with the 2 digits, separated by (-) and then the 4 digits

so, basically I need to take the last 2 digits and move them to the front separated by the dash.

all numbers are different...and I have 130,000 to fix.

is there a simple script or formula I can run on this column?

Any help would be greatly appreciated.
Thanks!

**martindwilson** · 09-03-2009, 04:00 PM

=right(a1,2)&"-"&left(a1,4)

**GonzoMoon** · 09-03-2009, 04:21 PM

Thanks! I'll give it a go.

**GonzoMoon** · 09-03-2009, 04:55 PM

Getting an error:

Compile error:
Expected: line number or label or statement or end of statement

any thoughts? I'll keep playing with it, but have to take off for a bit. I'll check back in.

thanks!

**martindwilson** · 09-03-2009, 05:05 PM

thats a function ,put it in a cell and drag down to end of data(assuming your data is in col a). then copy/ paste/ special /values back over the original then delete formula

**daddylonglegs** · 09-03-2009, 05:58 PM

Another way would be to use this formula

=MID(A1&"-"&A1,6,7)

**GonzoMoon** · 09-11-2009, 02:42 PM

I'm still getting the same error. Should there be additional code that will allow it to loop through all of the cells in a column. Though I can't get either of these codes to even change the first cell without getting the error.

Thanks for everyone's help. Sorry, I'm not a big excel user.

**martindwilson** · 09-12-2009, 06:30 AM

i said before its not vba put either in a spare column and drag down to end of your data.
when done simply copy then paste special values which will remove the formula and just leave the results