+ Reply to Thread
Results 1 to 3 of 3

Dynamic insertbreak function looks for special character instead of lenght

  1. #1
    Registered User
    Join Date
    05-26-2020
    Location
    Odense, Denmark
    MS-Off Ver
    2020 - 365
    Posts
    31

    Thumbs up Dynamic insertbreak function looks for special character instead of lenght

    HI forum,

    I have the following function in use at the moment that inserts a " ." every x character.

    Please Login or Register  to view this content.
    Example 1: Current
    text = .aaa.bbb.ccc.ddd.

    With a "=insertbreak(text;9) the function return above as: .aaa.bbb. .ccc.ddd. -- Which is correct.

    Example 2: Future
    tet2 = .aaaa.bb.ccc.dddd.
    So the future setup could vary in lenght of the text I want to divide.

    Im searching for a solution that could give me something like "=function(text2;x)" with the following result: .aaaa.bb. .ccc.dddd.

    How do i modify the function to do as intended?

    Thank you in advance
    Last edited by Ralleberg; 11-11-2021 at 09:37 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,188

    Re: Dynamic insertbreak function looks for special character instead of lenght

    Based on your examples ..

    =SUBSTITUTE(A1,".",". .",3)
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    05-26-2020
    Location
    Odense, Denmark
    MS-Off Ver
    2020 - 365
    Posts
    31

    Re: Dynamic insertbreak function looks for special character instead of lenght

    Quote Originally Posted by JohnTopley View Post
    Based on your examples ..

    =SUBSTITUTE(A1,".",". .",3)
    Really... That did the job.. Thank you John. Rep your way

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. replace function for special character in macro
    By sameeramavat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2020, 03:34 AM
  2. The user defined function to find any special character
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-19-2019, 08:12 AM
  3. [SOLVED] Excel Formula to Get the Middle data based on Special Character (Reverse Mid Function)
    By arnel_10 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-12-2017, 07:03 PM
  4. [SOLVED] Special Character
    By wacky_diva in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2016, 12:48 AM
  5. Copy substring until special character as a function/sub
    By gregersdk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-17-2016, 12:16 AM
  6. Need to highlight special character and the cells contains special character
    By dhilipan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2013, 01:36 AM
  7. [SOLVED] Split Cells based on Character Lenght
    By steve_aztec in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2013, 09:08 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1