Adding A space between an item:
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Adding A space between an item:

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I would like to add a space between "2236cwestcoast"
    I want it to look like "2236 c westcoast"
    Is this possible? Ican't seem to find anything in excel. Thanks for your help in advance...
    Dave

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,869
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-03-07 10:48, raffi74 wrote:
    I would like to add a space between "2236cwestcoast"
    I want it to look like "2236 c westcoast"
    Is this possible? Ican't seem to find anything in excel. Thanks for your help in advance...
    Dave
    Do you have more entries all with the same structure as the example you give ("2236 c westcoast")?

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I do have other entries that have the same structure.Also I have other entries with a different structure (with out the "c"
    eg..2210westcoast
    eg..2210cwestcoast
    on the first item I would like to take the left 4 characters.On the second item I would like to take the left 6 charaters after succesfully inserting a space"2210 c westcoast" Thanks again

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    =TRIM(REPLACE(SUBSTITUTE(A1,"westcoast"," westcoast"),5,0," "))

    where A1 contains your text string.

    [ This Message was edited by: Mark W. on 2002-03-07 11:16 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com