Cut #of char. from one column to another.

**James Callahan** · 04-23-2012, 09:40 AM

I can use Right formula to copy 6 char. from one column to another but if can't get those chars. cut from the first column. This is probably very easy.

**tom1977** · 04-23-2012, 09:49 AM

Hi with Vba yes but with formula I do not think so

**James Callahan** · 04-23-2012, 09:54 AM

How would you do it with Vba? This probably won't work with a variable number of rows.

**tom1977** · 04-23-2012, 09:56 AM

check such code

Please Login or Register  to view this content.

Paste this into module of worksheet

**James Callahan** · 04-23-2012, 11:45 AM

Tom1977:
Where does this fit in the module? I'm kind of new at this.
Thanks for your patience.

**tom1977** · 04-23-2012, 02:08 PM

Hi
select by mouse name of worksheet press right button of mouse and choose "view code" next paste this code into window which has appeared. Now try type into any cell some text longer the 6 characters.