Macro to cut and paste digits to a new cell

[ratter]

I've been searching the forum for a way to cut the first 3 digits from each cell in a column, and then to paste these 3 digits to a new cell/column.

It's got to be easy!

[ This Message was edited by: ratter on 2002-05-07 17:27 ]

[Barrie Davidson]

On 2002-05-07 17:25, ratter wrote:
I've been searching the forum for a way to cut the first 3 digits from each cell in a column, and then to paste these 3 digits to a new cell/column.

It's got to be easy!

[ This Message was edited by: ratter on 2002-05-07 17:27 ]

No need for a macro. Try using "Text to Columns". Select your column of data, select Data (from the main menu), select TextToColumns, specify fixed width and click next, click at position number 3 (creates a line break) and click next, select your formatting and click finished.

Does this help you out?

Regards,

[ratter]

If only I had known how easy! Thank you so much for taking the time to reply. This works perfectly. Kind regards, Paul