EXCEL - select first 4 characters, paste two col. over

[dh42891]

I have a couple hundred records that I need the first 4 characters from a certain column. I can get VBA to copy the entire cell, but I'm not sure how to tell it to only copy and paste the first four characters. Can anyone help? Thanks,

dylan

 

[xlhelp]

You don't need VBA to do this.

In the column where you want the 4 characters, type a formula.

Example

=Left(A2,4)

http://www.geniusmedia.ca

 

[SkipVought]

You can only copy and paste entire cells.

But there are STRING function like LEFT.
[tt]
=LEFT(A1,4)
[/tt]
returns the first 4 characters from the string in A1.


Skip,

_{[red]Be Advised![/red]
A wee deranged psychic may be runnin' around out there!
SMALL MEDUIM @ LARGE}

 

[AnotherHiggins]

You can do this with worksheet functions (without using VBA).
If your data is in column A, then in another column, use this formula in the second row:
[COLOR=blue white]=left(a2,4)[/color]

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[dh42891]

well i'll be damned. Thanks!

dylan

ps heck of a response time, appreciate that.