Multiple Columns On Same Side in Excel

Multiple Columns On Same Side in Excel

Postby Dennis Galon » Mon May 29, 2023 6:02 pm

I am creating simple two sided cards in Excel.
On one side, I need multiple columns of words.
In a single Excel cell, using a monospaced font, I created three columns of words, using spaces to force the columns to line up correctely. Two colors are used in each word, but I assume this is irrelevant to my problem.

In the following illustration, periods stand for spaces.
--------------------------------------
tom....dennis.harry
dennis.harry..tom
harry..tom....dennis
--------------------------------
Loaded into Flash Cards, every instance of multiple spaces is collapese to a single space.

Is there a way to fix this?
Or alternatively, using Excel, how do I create multiple columns of words on one side of a deck of cards?

Thank you!
Dennis Galon
 
Posts: 1
Joined: Fri May 11, 2012 10:34 am

Re: Multiple Columns On Same Side in Excel

Postby Katja from Hamburg » Tue May 30, 2023 10:53 pm

As html is used, there is no easy way to add spaces.

&nbsp
will add one additional space
Otherwise you need to create a table which is a lot of effort.
Katja from Hamburg
 
Posts: 318
Joined: Sat Oct 02, 2010 11:27 am
Location: Germany

Re: Multiple Columns On Same Side in Excel

Postby Guest » Wed May 31, 2023 6:38 pm

Meine liebe Katja,
Danke schon!!
Ich habe einen ganzen Tag damit verbracht und es nicht geschafft, das herauszufinden. Ich kenne kein HTML.
Herzlichen Dank!!

----
For anyone interested, the solution is simple enough:
In an Excel cell, using a monospace font, enter the columns using PERIODS for the spaces you need to line up your columns of words correctly. Then Find & Replace each "." with "&nbsp" (Which I assume means "non-breaking space")

If you use a monospaced font (eg. Menlo, Courier New) in Flashcard Deluxe, you get neat columns of words.

Once again, thank you, Katja.
Guest
 

Re: Multiple Columns On Same Side in Excel

Postby Ernie » Thu Jun 01, 2023 8:06 am

Hi Dennis,

Give this a try to see if it works for you...

.. = exactly TWO spaces

<list>
tom..dennis..harry
dennis..harry..tom
harry..tom..dennis

The "<list>" tag is custom for Flashcards Deluxe. The app will convert the above into a table. You might need to shrink font size to make it look better.
Ernie
Site Admin
 
Posts: 5007
Joined: Fri Oct 01, 2010 6:12 pm
Location: San Francisco / Taiwan

Re: Multiple Columns On Same Side in Excel

Postby Katja from Hamburg » Thu Jun 01, 2023 11:17 pm

Sorry, I was not aware of that. That makes some of my cards much easier to maintain.

@Ernie, do you mind to add this to "formatting text" on http://orangeorapple.com/Flashcards/Default.aspx and in the in-app help at "List, tables and outlines" with the same example.
Katja from Hamburg
 
Posts: 318
Joined: Sat Oct 02, 2010 11:27 am
Location: Germany

Re: Multiple Columns On Same Side in Excel

Postby Ernie » Tue Jun 06, 2023 8:43 am

Hi Katja,

Thanks for the suggestion. I added the following text to the website's main page, Formatting Text section:
"If you are creating lists (bulleted, numbered) or tables (with columns), search the in-app help for "Lists, Tables and Outlines" for more details."

I haven't updated the German version of the website yet, but I'll get a translation later.

I have a similar example already in the in-app help, under the "Tables" section in that help page. One possible confusing part is that I don't repeat the required <list> tag at top, which maybe I should to make it more clear.
Ernie
Site Admin
 
Posts: 5007
Joined: Fri Oct 01, 2010 6:12 pm
Location: San Francisco / Taiwan

Return to Comments, Questions and Feedback