truncation problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: mbk141 (mbk141.1erfty_at_excelforum-nospam.com)
Date: 10/27/04 

Date: Tue, 26 Oct 2004 19:57:07 -0500

Can someone help me with this. I've been away from VBA for over 2 years
and my mind is rusty.

I have a range selected that will be letters, then numbers as one word.
I want to add a hypthen in between the letters and numbers. How can i do
this VBA wise?

Ex.

abc123 -> abc-123
ghj1234 -> ghj-1234
wa76 -> wa-76

Thanks alot guys,
mbk 

-- 
mbk141
------------------------------------------------------------------------
mbk141's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15757
View this thread: http://www.excelforum.com/showthread.php?threadid=272676

Relevant Pages

  • Re: Create Mailmerge Envelope with VBA
    ... You are no doubt correct about using vba to create mailmerge mail ... Most of them find creating a mailmerge doc challenging. ... hit a button and get letters each month. ... generate the skeleton of a mail merge letter. ...
    (microsoft.public.word.vba.general)
  • Re: truncation problem
    ... I've been away from VBA for over 2 years ... >and my mind is rusty. ... >I have a range selected that will be letters, ...
    (microsoft.public.excel.programming)
  • Re: Adding sum of text
    ... equivalence of abcd in C1 ... string in C1. ... if you really want to put the letters in C1 ... and have the answer returned in the same cell, VBA is the only way. ...
    (microsoft.public.excel.misc)
  • Re: Determining first and last areas on multiple cells
    ... VBA works for me, but don't know that one either. ... and second cell and the rest may or may not be blank. ... > Hi Bob ... >> but it varies as I could only have two letters or thirty letters. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: If Then Else with mail merge faulty logic?
    ... The issue is that it will display "Matches" every time. ... letters. ... I've tried putting quotes around the condition (Word does this ... fields from VBa. ...
    (microsoft.public.word.mailmerge.fields)