+ Reply to Thread
Results 1 to 3 of 3

How to apply the same formatting for all lines?

  1. 03-14-2022, 06:52 AM #1
    Luu4466
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    175

    How to apply the same formatting for all lines?

    Good morning to the community.

    I am working on the folder "Data".
    Inside this folder I have 2 files:
    - Feuil1
    - Feuil2

    In the file "Feuil1", there are the raw data I receive.
    In the file "Feuil2", I designed the data I would like at the final point with the good format.
    CPY_0 NUM_0 LIN_0 TYP_0 DES_0 ACC_0 SNS_S AMTCUR_0 AMTLED_0 CUR_0 FIY_0 PER_0 ACCDAT_0 CREDATTIM_0 CREUSR_0
    A01 001-FNP-20-0000001 1 PPS FNP 006383 - SPIE BATIGNOLLES 231300 1 1083824.00000000000 1083824.00000000000 EUR 12 3 31/03/2020 00:00:00 28/03/2020 00:26:09 EXP

    I would like to automate the format whatever the number of lines i receive in "Feuil1".

    Thank you for your help.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Luu4466; 03-14-2022 at 07:14 AM.
    Reply With QuoteRegister To Reply
  2. 03-14-2022, 08:40 AM #2
    queuesef
    queuesef is offline
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: How to apply the same formatting for all lines?

    Go to the data Menu: then select : Data / Text to Columns / Delimited (radio button) / Comma (check this box & perhaps Tab too) | pick the formats you would like for each column OR try the default at 1st / FINISH
    Reply With QuoteRegister To Reply
  3. 03-14-2022, 11:23 AM #3
    Luu4466
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    175

    Re: How to apply the same formatting for all lines?

    Thank you for you reply @queuesef but I would prefer a VBA code to automate the process.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. apply conditional formatting
    By Danielrow in forum Excel General
    Replies: 13
    Last Post: 06-18-2020, 03:55 PM
  2. [SOLVED] Apply multi fields in 1 line instead of doing it on several lines
    By countryfan_nt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2017, 11:44 AM
  3. Apply conditional formatting to cells based on formatting of a reference cell
    By Marbleking in forum Excel General
    Replies: 1
    Last Post: 10-04-2016, 05:17 AM
  4. Check if one line has a value, and apply it all lines that match another criteria
    By menether in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-25-2014, 08:04 PM
  5. Apply formatting to all WS
    By amar05 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2013, 07:20 PM
  6. Conditional Formatting Help-is there away to apply this formatting down the entire co
    By braker1476 in forum Excel General
    Replies: 1
    Last Post: 11-12-2010, 03:18 PM
  7. [SOLVED] [SOLVED] Apply Two Fill Colours Between Lines in a Chart
    By Rick Andrews in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-10-2006, 05:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1