+ Reply to Thread
Results 1 to 2 of 2

How to align text in column next to the same text

  1. #1
    Registered User
    Join Date
    04-10-2022
    Location
    Czech Republic
    MS-Off Ver
    Newest
    Posts
    4

    How to align text in column next to the same text

    Lets say you have 50 categories, 1 in every single column from top to bottom, but you have only 26 examples (text and numbers), and when I paste these 26 examples they again go from top to bottom, but what if I dont want them from top to bottom, but instead next to the already made categories. Is there any sorting option for this ?

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,947

    Re: How to align text in column next to the same text

    You need to show some sample data, with before and after and an explanation of your logic.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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] Text to column align right
    By minhys1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-10-2022, 09:27 PM
  2. [SOLVED] Align Text in a Listbox but diferent for each column
    By jcastrejon1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2019, 06:32 PM
  3. VBA excel to word insert footer (Text - Left align) & (Page number - Right align)
    By Richavlaues in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2017, 06:22 PM
  4. [SOLVED] How do I align text left the horizontal axis labels and wrap text them?
    By rs1aj in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-11-2015, 03:52 AM
  5. [SOLVED] Format align text in column when export to excel with VBA
    By Cuong Pham in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2013, 12:11 AM
  6. Align text box to a column
    By ajaykgarg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2010, 08:18 AM
  7. [SOLVED] Set the text align property of each individual column on UserForm1.ListBox1.ColumnCount = 5
    By Drom in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2005, 05:21 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