Add multiple spaces in a cell

[Rav_Singh]

I hope someone can assist with what seems a simple formula that I have failed to grasp.

In the example below I would like to add spaces before a value in a cell depending upon the value in another cell.

Example:

Column A - Text
Monday
Tuesday
Wednesday

Column B - Number of Spaces
2
4
6

Column C - (How the data should hopefully look)
__Monday (2 spaces before text)
____Tuesday (4 spaces before text)
______Wednesday (6 spaces before text)

If anyone can assist that will be greatly appreciated.


Rav

 

[lrobbo314]

=rept(" ",b1)&a1

 

[JoeMo]

Copy C2 down. May not look like it does on my worksheet, but the spaces are there as confirmed in col D.

Excel Workbook
	A	B	C	D
2	Monday	2	Monday	8
3	Tuesday	4	Tuesday	11
4	Wednesday	6	Wednesday	15
Sheet1

 

[Rav_Singh]

Dear Irobbo314 and JoeMo,

This was perfect. Learning something new everyday.

Many thanks,

Rav