Combining a range of cells' contents into 1 cell

[macrode]

I'm kind of new to macros and would like to get the code for a task.

The task is simple: combine the contents of the selected cells into one cell.

e.g. I have the word "computer" split into 3 consecutive cells in the same row;

A1="com", B1="put", C1="er"

I want the macro to cut the contents of the selected cells and paste them together, in the same cell, the first cell selected.

A1="computer"

Any ideas appreciated.

[mikerickson]

This UDF might help. It can be called either from the worksheet or from VB.

Please Login or Register  to view this content.

[macrode]

The best way to describe the task is - reverse 'text to columns' - I'm not even sure i need a macro.

Thanks for the reply.

I pasted the code into a blank macro and got the error "expected end sub". Do i use the 'function'; within the sub, after the sub, or instead of the sub?

I am new to this so please tell me exactly how to use that code.
And how do i "call it from the worksheet"

Thanks