Dear Sir,
Please note my Group names are in BOLD font.
I wanted to get the Ledger Group name in front of the ledger.
For Example, Ledger Name is “ABCD BANK” and Group Name is Bank Accounts
I want result Like Column “A” ABCD BANK and Bank Accounts in Column “B”
Please Help.
Hi Sarfraz,
Excel is not designed to work with formatting as data.
I recommend you get a list of the account groups and accounts in the correct format (the database it came from will have it correctly stored), then you can do a lookup with a formula or Power Query to bring the account group into column B.
Mynda
Dear Madam,
Is it possible to filter data only BOLD formatted data so I can easily copy and paste ?
No, filters only work with font colour and fill colour.
If you do not have access to the account group table from the original database, you can use VBA to separate the accounts from the groups. You can ask ChatGPT to write the code for you and if you get stuck, you can post your question in our VBA forum.
Mynda
