Excel file Techniques…

Assalamualaykum Wr Br…
A nice and cute trick with excel I found quite interesting and thought to share it and here it is:
1. I have a excel file as shown below:
excel
2. Need to append single quote at the begining and end of the data as ‘Aejaaz’..Which can be done as:
a. Click any cell(here I clicked B1 cell). And write the formula in formula bar as =”‘”& F1& “‘” and hit enter key.
excel1
b. Now drag the B cell and get the result as expected as shown below:
excel2
Jazakallah Khair…

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s