HELP! How do I double an amount of figures in a table?

[KikkoAndMoonman]

Dear all,

Need some help here! I have a table (see untitled.JPG) which contains a data count of appointments. Each appointment is defined by a "1", therefore if in one day I had 5 appointments, it would have "11111" in the section.

I have been asked to take all the figures and double them. Is there a way to do so that the amount of 1's in each box is double, so if I had "11" it would become "1111"?

Would really appreciate your advice! Many thanks in advance.

untitled.JPG

[rcm]

yes, since the length of each cell is the number of appointments prepare another worksheet so that in each cell there are 2 times the contents of the original cell

in a macro, for each cell containing "1" ,copy twice the original value

if you send a sample in excel, I'll gladly work on it

[FDibbins]

Hi and welcome to the forum

Using this suggestion will mean creating a duplicate table, then using this formula in the new table, copied down and across...
=REPT(A1,2)*1

You can then (if you want to) copy/paste values over the original table, and then delete the "new" table"

[KikkoAndMoonman]

Hi RCM,

Many thanks for your reply. As I'm annoyingly not permitted to send any thing to do with this spreadsheet over, could you perhaps screenshot your doing the macro, so I can apply the same to all my "1"s?

[KikkoAndMoonman]

SOLVED:

By using the Find and Replace tool, I managed to double all the 1's by replacing 1 with 11.

Thanks nonetheless for your feedback and trying to help me