Results 1 to 10 of 10

Replace "Comma Space" with New Line (Line Break(

Threaded View

  1. #1
    Registered User
    Join Date
    02-20-2021
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    9

    Replace "Comma Space" with New Line (Line Break(

    Hello,

    I have an excel file which has around 1500 rows of data. One of the column contains information as- City 1, City 2, City 3, City 4, City 5. Some of the cells has over 50 city names.


    I need the same data but with line break without comma as explained below-

    City 1
    City 2
    City 3
    City 4
    City 5

    Thank you!
    Attached Files Attached Files
    Last edited by Sam17; 03-06-2021 at 07:01 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Replace Line break with Comma without changing color format
    By Kinjal Doshi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2020, 06:56 AM
  2. Replies: 4
    Last Post: 10-21-2020, 11:42 PM
  3. Help with "Insert a line break in a cell"
    By mrbret in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-30-2018, 05:20 PM
  4. line of visual basic to replace NA with "-" on sheets
    By JPSIMMON in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2014, 05:06 PM
  5. Replies: 0
    Last Post: 01-29-2014, 08:10 PM
  6. controlling the format of a "Line Break"
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2013, 11:53 AM
  7. Replies: 4
    Last Post: 12-29-2009, 08:11 PM

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