+ Reply to Thread
Results 1 to 2 of 2

add a character to every cell

  1. #1
    Registered User
    Join Date
    04-14-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    127

    add a character to every cell

    Hi everyone,

    I have a problem in my excel. I am trying to add a character "zz" in front of every text in one column.
    For example: if the text is "XYZ", then I want it to become "zzXYZ".

    I wanted to understand if there is a formula to add a character example "zz" as a prefix character.

    Thank you very much in advance for any help.

    Regards,
    Vikas

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: add a character to every cell

    ="zz"&A1 will do that for you.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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. [SOLVED] Remove first character in a cell when the second character is blank
    By eastdallasguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2013, 03:11 PM
  2. Changing last character in a cell based on the character before it
    By Falcongbz in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 04-29-2013, 12:31 PM
  3. Replies: 3
    Last Post: 11-20-2012, 10:03 PM
  4. Macro to find character and delete all text in cell after the character
    By SpencerRichman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2012, 06:08 PM
  5. Display Active Character Count + Limit Character Per Cell
    By euronail in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2011, 04:59 AM

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