Results 1 to 4 of 4

How to insert a different numbers of character in a part of a text?

Threaded View

  1. #1
    Registered User
    Join Date
    02-18-2020
    Location
    Lithuania
    MS-Off Ver
    365
    Posts
    2

    How to insert a different numbers of character in a part of a text?

    Hello everyone,

    I do not invent (or I do not know Excel well) functions that make my life easier.
    It is necessary to insert the symbol "0" in a certain place of the cadastral number. The difficulty comes from the fact that the numbers are not of the same length, i.e. you need to insert a different quantity "0".
    Like this:
    9584/0005:12 ---> 9584/0005:0012
    9552/0001:9 ---> 9552/0001:0009
    6899/0002:194 ---> 6899/0002:0194

    Can anyone help with formula?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Insert column Text after first non blank character
    By rexrundajets in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2018, 10:30 AM
  2. [SOLVED] Bold part of text that appears before special character
    By Mitiraj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2016, 11:19 AM
  3. Extract text left and right of character part 2
    By stuartm4h in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-01-2013, 07:12 AM
  4. [SOLVED] Insert space in part numbers
    By Allgermanparts in forum Excel General
    Replies: 4
    Last Post: 06-19-2013, 09:00 AM
  5. [SOLVED] Need to insert character (dash) between part numbers
    By BYizz in forum Excel General
    Replies: 3
    Last Post: 10-04-2012, 02:21 PM
  6. Insert a character between letters and numbers
    By whipkey in forum Excel General
    Replies: 3
    Last Post: 01-20-2011, 12:28 PM
  7. Replies: 3
    Last Post: 01-18-2006, 01:10 PM

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