2015/07/23

Excel: 行の全ての文字に,「様」などの特定の文字を付加する方法

Excel Mac 2011, OS 10.9. おそらく他のバージョンでも使える方法。

鈴木
佐藤
市ノ瀬
田中
中野

などの文字が縦に並んでいるときに,全部に「 様」(半角スペース + 様)をつけたいとする。
鈴木が A1 の位置にあるとしたら,一つ右の列を

=A1&" 様"

として,一番下までオートフィルする。あとは行全体をコピーして,値として貼付ければOK。
このほか,B の列に「 様」をひたすら並べ,C の列を =A1&B1 としてオートフィルしても同じ結果になる。

この他の小技は Excel の使い方のページ を参照。

Comments

Private comment

No title

I visit daily some web pages and blogs to read articles or reviews, but this blog gives quality based writing.

No title

This post is worth everyone's attention. Where can I find out more?

No title

I was wondering if you ever thought of changing the page layout of your site?
Its very well written; I love what youve got to
say. But maybe you could a little more in the way of content
so people could connect with it better.
Youve got an awful lot of text for only having 1 or 2 images.
Maybe you could space it out better?

No title

Sweet blog! I found it while surfing around on Yahoo News.

Do you have any suggestions on how to get listed in Yahoo News?
I've been trying for a while but I never seem to get there!
Many thanks

No title

Hey would you mind sharing which blog platform you're working with?
I'm planning to start my own blog in the near future but I'm having a difficult time making a
decision between BlogEngine/Wordpress/B2evolution and Drupal.
The reason I ask is because your layout seems different then most blogs and I'm
looking for something unique. P.S My apologies for getting off-topic but I had to ask!

No title

Today, while I was at work, my sister stole my iphone
and tested to see if it can survive a twenty five foot drop, just so she can be a youtube sensation. My iPad is now destroyed
and she has 83 views. I know this is completely off topic but I had
to share it with someone!

No title

I think the admin of this web page is actually working hard in favor of his web site,
for the reason that here every material is quality based material.

No title

I'm contemplating a wooden privateness fence.

No title

What's up friends, its fantastic post regarding educationand completely explained, keep it up all the time.

No title

Hello, its pleasant post about media print, we all be aware of
media is a enormous source of facts.

No title

Excellent pieces. Keep writing such kind of info on your blog.

Im really impressed by your site.
Hi there, You have done a great job. I'll definitely digg it and personally recommend to my friends.
I'm sure they will be benefited from this website.

No title

I used to be able to find good advice from your content.

No title

After checking out a few of the blog posts on your web page, I really appreciate your technique of writing a blog.
I saved as a favorite it to my bookmark website
list and will be checking back in the near future.
Take a look at my web site too and tell me how you feel.

No title

I am extremely impressed with your writing skills and also with the layout on your weblog.

Is this a paid theme or did you modify it yourself?
Either way keep up the excellent quality writing, it's rare to see a great blog like this one today.

No title

Asking questions are in fact nice thing if you are not understanding something completely, but this post presents
fastidious understanding yet.

No title

The correct advice can save you money and
time.

No title

I have learn several excellent stuff here. Certainly value bookmarking for
revisiting. I surprise how much effort you put to create
one of these magnificent informative website.

No title

The best advice can save you money and time.

No title

The suitable recommendation can prevent money and time.

No title

Hey! Do you know if they make any plugins to help with Search Engine Optimization? I'm trying to get my blog to rank for
some targeted keywords but I'm not seeing very good gains.
If you know of any please share. Thank you!

No title

The correct recommendation can save you time and money.

No title

My brother suggested I might like this website. He was once entirely right.
This put up actually made my day. You cann't imagine
simply how much time I had spent for this information! Thanks!

No title

Chain-hyperlink fences are especially cost-efficient.

No title

I just couldn't depart your website before suggesting that I actually loved
the standard info an individual provide to your visitors?
Is gonna be again ceaselessly to check up on new posts

No title

The common building permit prices about $800.

No title

I just like the helpful information you supply for your articles.
I'll bookmark your blog and check once more right here
frequently. I am relatively sure I'll learn a lot of new stuff
right right here! Best of luck for the next!

No title

I'm extremely impressed along with your
writing talents and also with the structure on your weblog.
Is that this a paid topic or did you modify it your self? Either way keep up the
nice quality writing, it's uncommon to look a nice weblog
like this one these days..

No title

Hey there! I know this is somewhat off topic but I was wondering if you knew where I could locate a captcha plugin for my comment form?
I'm using the same blog platform as yours and I'm having difficulty
finding one? Thanks a lot!

No title

6' wooden fences run about 1$18.00 a foot.

No title

Hey I know this is off topic but I was wondering if you knew of any widgets I
could add to my blog that automatically tweet my newest twitter
updates. I've been looking for a plug-in like this for quite some time and was
hoping maybe you would have some experience with something like this.
Please let me know if you run into anything. I truly
enjoy reading your blog and I look forward to your new updates.

No title

Heya i'm for the first time here. I came across this board
and I find It really helpful & it helped me out much.

I'm hoping to give one thing back and aid others
such as you aided me.

No title

Chain-hyperlink fences are particularly price-efficient.

No title

The common constructing allow costs about $800.

No title

My partner and I stumbled over here different web address and thought I might check things out.
I like what I see so now i'm following you. Look forward to exploring your web page again.

No title

6' wooden fences run about 1$18.00 a foot.

No title

The typical building permit prices about $800.

No title

This is my first time go to see at here and i am actually happy to read all
at alone place.

No title

Chain-link fences are particularly cost-effective.

No title

Marvelous, what a website it is! This blog gives valuable data to
us, keep it up.

No title

The typical constructing allow costs about $800.

No title

Hi, just wanted to say, I liked this blog post. It was helpful.
Keep on posting!

No title

Hi! I simply want to offer you a huge thumbs up for your excellent information you have right here on this post.
I am returning to your blog for more soon.

No title

Very good blog! Do you have any hints for aspiring writers?
I'm planning to start my own blog soon but I'm a little lost on everything.
Would you suggest starting with a free platform like
Wordpress or go for a paid option? There are so
many choices out there that I'm totally
overwhelmed .. Any recommendations? Thanks!

No title

Wow, this post is good, my sister is analyzing these things, so I am going to inform her.

No title

Aw, this was a really good post. Finding the time and actual effort
to make a superb article… but what can I say…
I put things off a whole lot and never seem to get nearly anything done.

No title

I'm curious to find out what blog system you're using?
I'm having some small security problems with my latest website and
I'd like to find something more secure. Do you have any solutions?

No title

First of all I want to say terrific blog! I had a quick question that I'd like to ask if you do not mind.
I was curious to know how you center yourself and clear your mind before writing.
I have had trouble clearing my mind in getting my
ideas out. I truly do enjoy writing however it just seems like the first 10 to 15 minutes are usually
lost just trying to figure out how to begin. Any suggestions
or tips? Many thanks!

No title

That is a good tip especially to those new to the blogosphere.
Brief but very accurate information… Many thanks for sharing this
one. A must read post!

No title

Hello, i think that i saw you visited my weblog thus i came to “return the favor”.I'm trying to find things to improve my web site!I suppose its ok to use some
of your ideas!!

No title

Thanks for your marvelous posting! I truly enjoyed reading it,
you're a great author. I will be sure to bookmark your blog and definitely
will come back from now on. I want to encourage that you continue your great posts, have a nice
day!

No title

Hi there! I know this is kinda off topic but I was wondering which blog platform are you using for this site?
I'm getting tired of Wordpress because I've had
issues with hackers and I'm looking at alternatives for another platform.
I would be great if you could point me in the
direction of a good platform.

No title

With havin so much content and articles do you ever run into any issues of plagorism or copyright infringement?
My website has a lot of exclusive content I've either created
myself or outsourced but it looks like a lot of it is popping it
up all over the web without my permission. Do you know any techniques to
help stop content from being ripped off? I'd definitely appreciate it.

No title

It's appropriate time to make a few plans for the long run and it's time to be happy.
I've learn this post and if I could I want to recommend you
some fascinating issues or suggestions. Perhaps you can write
next articles referring to this article. I want to learn more things approximately it!

No title

Certified Financial Planner Board of Standards Inc.

No title

With investing, your capital is at risk.

No title

Investor researches stocks, bonds, etc.

No title

Investor researches stocks, bonds, and so forth.

No title

Investments in most securities contain dangers.

No title

Investor researches stocks, bonds, and so on.

No title

That is what Methodology Actors name 'sense memory'.

No title

I studied in a couple of colleges for acting.