Modifying Text in a column

[Bob]

Hello,

I have a long column of text cells, each of which has a single piece of
text in each cell.
e.g., abc

How can I change all the cells to have each cell modified by the
addition of another piece of text added to it (no spaces)

e.g.

xyz becomes xyzK
agh becomes aghK
vtd beomes vtdK
etc.

Same "add-on" in each case.

Thanks,
Bob

 

[Cimjet]

Hi Bob
You can do it this way, assuming your data starts at A1 going down, just type
=A1&"k" and copy down, it will adjust by itself.
HTH
John

 

[Bob]

Hi,

Thanks for help; much appreciated.

Almost what I want, but not quite.

When I do as you suggested, it puts a space between what's there, and
what's now appended to it. e.g., zyz K

I want one contiguous piece of text. e.g. xyzK

Possible to do this way ?

Thanks again,
Bob
--------------------------------------------

 

[Cimjet]

Hi Bob
Try it again, if you don't put a space, you should't get a space.
HTH
John

 

[Bob]

Hi,

Thanks for all the help with this.

I'm pretty sure that I'm not doing it the way you are suggesting.
Assume you're dealing with a complete incompetent with this.

My original data is in the A column as A1, A2, A3, etc.

Do I click on A1 and in the formula bar write =a1&"k"
This can't be right, as when I click on a1, xyz, of course, comes up.

If I just click on a blank cell somewhere, and in it write =A1&"K"
I get the right result, but with a space, as I noted previously.

Could you please outline for me, in excruciating detail, the exact steps
(and where) I should follow ?

Thanks again.
Nice of you to take the time to help me out.

Bob
-------------------------------------------------

 

[Gord Dibben]

If I just click on a blank cell somewhere, and in it write =A1&"K"
I get the right result, but with a space, as I noted previously

That's how you do it.

Any space generated is from you entering a space in the formula.

Copy this formula and paste it into B1

=A1&"K"

Do not type it, copy and paste using CTRL + c and CTRL + v

After you have seen the results............with no spaces..........copy down
column B by double-clicking on the fill handle on bottom right corner of B1


Gord Dibben MS Excel MVP

 

[Cimjet]

Hi Again
Find attached a link to a sample file, download it and you will see what I did.
http://cjoint.com/?0mecEX5Crlj
If you're getting a space between, it's possible that your data has got a none
printing space in the cell itself.
Try the formula on an other sheet with data you type yourself.
If your importing data from the Internet, it's possible that your getting those
blank space.
HTH
John

 

[Cimjet]

Hi Bob
This is a link to You Tube showing the formula "concatenate" done in different
ways.
I think you'll find it interesting.

HTH
John

 

[Bob]

Hi all,

Realize how much time and effort everyone is putting into helping me,
and want to make sure that you know how much I appreciate it.

A bit more:

The data came from a table of radio frequencies, and their
descriptions,I copied and pasted into Excel 2007.
I then formatted it as a .csv and did a Text to column operation on it
to put the number, and it's description, in separate columns

My guess is that this is where the problem arises from.
As mentioned, it is likely that there is some "hidden code", or... from
either, or both, of these operations.?

Anyway, here's a small snip of what is happening.
Won't let me Paste it, but this is what it shows:

2657 2657 K
2657 2657K


In the first row, is a normal copy and paste from the data.
Doing the operation on it, yields the "space" we are all talking about.

The second row down, I just wrote the number, and the operation yields
no space, as expected.

Visually, both 2657's appear to be in the extreme left hand position in
their cell, and both as best I can tell are formatted as regular Text
(but possibly not, or with something hidden ?).
They sure do look the same.

So, there must be something hidden in the data.

I will play around with this some more, read the excellent links that
have been suggested, and if I find out what the problem was, will Post
back here.

Thanks again,
Bob
--------------------------------------

 

[Cimjet]

Hi Bob
Have a look at this video, it's removing extra space.

You may need a macro to remove those extra space but try what's on the video
first.
Good luck
John