Raymonbell's Posts

Nairaland Forum › Raymonbell's Profile › Raymonbell's Posts

1 2 3 4 5 6 7 8 9 10 (of 15 pages)

Politics › Re: Is It Corruption That Has Made PHCN Kept Us In Darkness? by Raymonbell(m): 6:05pm On Sep 11, 2017

Albert0011:
Nigerians sha,using our hand to kill ourselves... here in Monaco France,i have neva experienced any thing like power failure or black out 4 the past 2 yrs now.

Okay, now we know you're in Monaco

Food › Re: Manta Ray: Fish Caught In Bayelsa State. Photos by Raymonbell(m): 12:13pm On Aug 07, 2017

Manta Alfredi

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 11:59am On Jul 31, 2017

asocubed:
Good morning, Raymonbell

Thumbs up for the tutorials, really grateful. More knowledge, boss.

You're welcome Boss

1 Like

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 2:56pm On Jul 30, 2017

johnime:
Wtf happened to this thread.

Alive and alive

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 5:24am On Jul 28, 2017

Still here
Anybody around

Romance › Re: At Age 24 I Don't Have A Girlfriend, Have Not Been Loved By Any Girl by Raymonbell(m): 3:28pm On Jul 23, 2017

alienhumam:
I spent four years in the university without a girlfriend, because am afraid to approach girls. I don't want to be rejected. people gossip about me that am gay. because am always in company of guys. even my male friends are even accusing me of been gay, which I know am not. The even joke with me with jokes like
I can't sleep in one bed with you and so on.

Now what I need is advice from Nairalanders on how I can get a girlfriend that can love me. Because very soon I will be going to national youth service. am depressed because of my situation I need help.

And so?

I think your problem is not girlfriend related but a grown up man with low self-esteem.

Oga, raise your head and walk like a niga

Don't give a f@uk about what people say

1 Like

Phones › Re: The Xiaomi Thread. by Raymonbell(m): 1:35pm On Jul 17, 2017

Finally, I joined the Xiaomi family

1 Like

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 5:35pm On Jul 11, 2017

TES2LA:
This is cool.... Nice one broh.

Thanks Man

Kindly Join me in keeping the thread alive

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 8:25am On Jul 11, 2017

Good Morning

We are still here

Regards

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 2:16pm On Jul 09, 2017

jasmine1:
Thanks gidi gaan!

You're welcome

Cc

Mod

Raymonbell:
Mod

Kindly push this thread to FrontPage or other forums for others to benefit and learn something new

Cc
crazyMan
1forall

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 12:08pm On Jul 09, 2017

jasmine1:
Good job bro!

Please how do change sentences from capital letters to small letters or vice versa

Thank you, Boss

You'll need excel functions to achieve that.

To change all text to capital letter

1. Select an empty cell (e.g Cell B1)
2. Type =Upper(A1) into cell B1.
I assumed you're changing text in cell A1. If not, change the A1 to the cell you want to change its case
3. If you want to change entire column just drag the first

To change all text to lower case

1. Select an empty cell (e.g Cell B1)
2. Type =lower(A1) into cell B1.
I assumed you're changing text in cell A1. If not, change the A1 to the cell you want to change its case
3. If you want to change entire column just drag the first

To change the first alphabet to upper case ( Sentence case)

1. Select an empty cell (e.g Cell B1)
2. Type =Proper(A1) into cell B1.
I assumed you're changing text in cell A1. If not, change the A1 to the cell you want to change its case
3. If you want to change entire column just drag the first

I hope this help

Note:

=lower(A1) to change all alphabet to lower case

=upper(A1) to change all alphabet to capital letter

=proper(A1) to change all alphabet to sentence case

I'm using A1 as reference change it to the cell you want to affect in your worksheet

4 Likes 1 Share

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 10:59am On Jul 09, 2017

johnime:
Thank I will try it out

You're welcome

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 9:14am On Jul 09, 2017

johnime:
How do you freeze the third row or fifth column?

Good Morning

To freeze Row 4

1. Click on 5 on the row number
2. Click on VIEW on the ribbon
3. Under the WINDOW GROUP look for freeze pane
4. Click on Freeze Panes

DONE

To Freeze Column 5

1. Click on F to highlight column 6
2. Click on VIEW on the ribbon
3. Under the WINDOW GROUP look for freeze pane
4. Click on Freeze Panes

DONE

If you want to freeze both (Row 4 & Column 5) at a time

1. Click on cell F5 to highlight the cell
2. Click on VIEW on the ribbon
3. Under the WINDOW GROUP look for freeze pane
4. Click on Freeze Panes

You're done

1 Like

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 1:00pm On Jul 07, 2017

We are still here

Let's collaborate to solve your Excel challenges

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 8:39am On Jul 06, 2017

timmyblast:
nice i also learnt that it can be done with these formular: =A1&" "&B1

Yes, using & is another simple way to concatenate cells

Thank you for sharing

Kindly check in regularly to share your knowledge with others

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 3:20pm On Jul 05, 2017

Smoak:
Good work!
I wish I saw this thread two weeks ago,had a serious excel wahala....sorted out myself now tho...

That's good

That's how we learn bit by bit

You can join me in keeping the thread alive for others to benefit

You can also share your challenge and how you solve it

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 3:13pm On Jul 05, 2017

timmyblast:
i want to merge content on 2 cells to form 1. i.e name n surname to be on one cell.

Sorry for the late reply

That is easy, all you need is an Excel function called "CONCATENATE"

I assume the data is in two different column (Column A and Column B) and you intend to insert your new data in column C

Follow this simple step

1. Create a new column for your new data. E.g Column C
2. On cell C1 type =Concatenate(A1," ",B1)
3. Hit enter button
4. If you want to do the same for all data on column A and B drag the cell down or double click the small black box on cell C1
5. You're done

Let me know if that solves your challenge

In case you want to merge more than one column just extend the formula like this

=concatenate(A1," ",B1," ",C1," ",D1)

You can add as many cells as possible

Note: " " this allow me to insert a space between the value you're merging together

3 Likes 1 Share

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 3:12pm On Jul 05, 2017

Sorry for the late reply

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 7:17am On Jul 05, 2017

Good morning,

I'm still here

Just ask and it shall be given for free

Regards
Raymonbell from

1 Like

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 9:43pm On Jul 03, 2017

Keeping the thread alive

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 10:16am On Jul 02, 2017

Mod

Kindly push this thread to FrontPage or other forums for others to benefit and learn something new

Cc
crazyMan
1forall

Education › Re: My Daughter's Teacher Asked Them To Write "Who Is Evans?" by Raymonbell(m): 9:19pm On Jul 01, 2017

jagugu88li:
From your post I am sensing you had an attitude towards the teacher for you believed the assignment was irrelevant. I think you used a tone that made him reply in an unpleasant manner.

Both you and the teacher are wrong ma. Mind you, I am only speaking based on what I am sensing given your post.

The assignment is very relavent. At the end of the day people were kidnapped (bad) and lives were lost (2bads) all because of greed (give it a name) and he ended up in jail (greed has that tendency). Very relevant ma. Someone said current affairs, I say + life orientation

Thank you jare

Conversation btw OP and Teacher

OP: Hello Mr. Teacher

Teacher: Good evening OP, how are you today?

OP: How dare you ask my child to write about Evans

Teacher: Ohh! It's a topic we are discussing and your child will present her findings to her classmates

OP: Never give my child that kind of topic again in your life

Teacher: Excuse me!

OP: You heard me, are you a qualified teacher self?

Teacher: You have no right to question my competency Sir

OP: I paid you to teach my kid, so I do

Teacher: Good day Mr. OP

Teacher bang the phone

1 Like

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 4:29pm On Jul 01, 2017

jefy:
thanks for your elaborate answer to my question. I'll try out all that you have suggested. Gracias

Glad to help

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 10:24am On Jul 01, 2017

jefy:
glad to be here,
I want to find out how I can effectively copy and paste large Data, without distortions in the numbers? if I copy and paste into another sheet, the numbers automatically changes. what do I do? plus, will it be possible for me to get a simplified excel manual for use in cases of uncertainty? Thanks as I hope for your reply.

Sorry for the late reply

Are you copying an entire sheet of part of a sheet?

If you're copying an entire sheet use this method

1. Right on your sheet name
2. Click 'Move or Copy' option
3. Select the position of the new sheet e.g (move to end)-the last sheet on the workbook
4. Select create a copy
5. Click OK

A new sheet will be created with all your data and formula intact.(Just the way it's in your original sheet).
I love this option because it allows me to create multiple copy of a sheet and allow all formula and Macro embedded in my original sheet to be copied.

If you're copying part of a sheet use this method

1. Highlight the data you want to copy
2. Use Ctrl+C or right click to select copy
3. On the HOME tab under the clipboard option you'll see paste.
4. There're several way to paste in excel and that depend on your need. Toggle the paste option available till you get the exact paste option you need.

If you can't find the option you need

1. Click paste special and you'll see other options
2. Click okay once you find your favorite option

What kind of excel manual do you need? Can you explain a little further

I hope this helps

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 11:33pm On Jun 30, 2017

DEBUCHMANNY:
Done! thanks, you just saved me sleepless night. my supervisor go hiaram on Tuesday

Go kick their aخsss bro

Glad to help

Career › Re: Data Science In Nigeria by Raymonbell(m): 7:15pm On Jun 30, 2017

Data Science is cool and people making money from it seems unwilling to attract people into the field.

If you follow through with your training you won't regret it.

Talking from experience

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 10:04am On Jun 30, 2017*

Weekend

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 10:14pm On Jun 29, 2017

DEBUCHMANNY:
word 2013 bro.

1. Highlight your data
2. On the insert tab create your chart e.g bar chart
3. Now click on your chart to activate the Design and format tab
4. Click on the format tab
5. At the right hand corner you'll see "format selection" and right above it you'll see a drop down menu
6. On the drop down menu click on the series (Data) you want to place on your secondary axis
7. Then click format selection
8. Chart dialogue box will open beside your graph and you'll see primary and secondary axis
9. Click on secondary axis to place that data on the secondary axis.
10. If you need to reformat your graph, click on the design tab to change chart type and redesign to your taste.

I hope this helps

I typed this offhand without my PC but I'm sure the process above is correct.

2 Likes 1 Share

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 4:26pm On Jun 29, 2017

DEBUCHMANNY:
thanks! want to plot a graph with two different vertical axis on the same horizontal axis. I need assistance.

Career › Re: Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 4:26pm On Jun 29, 2017

DEBUCHMANNY:
thanks! want to plot a graph with two different vertical axis on the same horizontal axis. I need assistance.

What version of Excel are you employing?

Career › Excel Thread: Post Your Spreadsheet Challenges by Raymonbell(op): 4:04pm On Jun 29, 2017

Hello everyone,

Welcome to Nairaland Excel thread.

I noticed most Excel users struggle with their worksheet especially writing Macro or recording one for repeated task. I created this thread to share my knowledge and learn from other Excel pros.

Let's maintain the sanctity of this thread and help fellow professional and job seekers with their task. Out of my busy schedule, I will try to check in regularly and respond as soon as possible.

Kindly explain your challenge(s) with excel as clear as possible and Nairaland gurus will create a solution for you.

cool

Phones › Re: The Xiaomi Thread. by Raymonbell(m): 5:57am On Jun 22, 2017

Guys I have like $70 in my Alipocket, can you guys checkout or fund my Alipocket.

Very urgent

Cc
Noobody, rookidmart, emaminaj, protein0

1 2 3 4 5 6 7 8 9 10 (of 15 pages)