Hi all,

What is macro used for in Excel?

Any insight is useful.

Could be a basic question but for me it's like a mountain.

Thank you

Excel macro or script that can make all data into caps in a excel sheet Some easy way which I can use to make all words CAPS.

Hi Experts,

How can i remove a single space from the front of each cell in a Column.

I want a formula that i can use to remove one empty space in front of each words or words in the cell.

I have data as below

You can see in the above table the start is a space. need to remove it

Thanks in advance

Srene

Simple excel question. How can i convert a row of data into column

I have an excel in Row 1 i have 100+ cells of data.

I want to get them into a Column

Can anyone help me with a script or a inbuilt way to achieve this.