Ask Your Question
0

Appending text to a column of data. [closed]

asked 2014-07-18 00:31:55 +0200

Fogest gravatar image

I have some data, here is a sample of it:

cs-rsg@cs
cs-rsg-hci@cs
cs-rsg-ds@cs
cs-rsg-ai@cs
cs-rsg-ai@cs
cs-rsg-scg@cs
cs-rsg-npsg@cs
cs-rsg-bif@cs
cs-rsg-ds@cs
cs-rsg-ds@cs
cs-rsg-ds@cs
cs-rsg-iqc@cs

To all the above I want to append some text to the end of them. The same text to each. Use the following text for example: ".appended.text.com"

What I did to get the correct result for this was concentrate the data in a formula. For example:

=B5&".appended.text.com"

The problem is that I want this appended so I need this newly generated output copied back to the old column. The problem is that it won't let me do this. "Insert into multiple selection not possible".

So what am I suppose to do now?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-29 21:56:05.067129

2 Answers

Sort by » oldest newest most voted
1

answered 2014-07-18 01:00:55 +0200

m.a.riosv gravatar image

There are three ways to copy and paste only the text (after copy):

1- Right-click - paste only - text.
2- Paste special [Shift]+[Ctrl]+V, and select only text to past.
3- Click on the right arroy of past button selecting unformatted text.

edit flag offensive delete link more

Comments

The option is "Paste Special" and the problem here is that it still gives the error I described.

Fogest gravatar imageFogest ( 2014-07-18 01:44:11 +0200 )edit
1

Please what are the ranges with data and with formulas?

m.a.riosv gravatar imagem.a.riosv ( 2014-07-18 03:16:19 +0200 )edit

Options work exactly as @mariosv specifies under GNU/Linux. @Fogest you may be experiencing a problem related to your O/S or LO version (neither of which have been specified).

oweng gravatar imageoweng ( 2014-07-18 03:24:19 +0200 )edit
0

answered 2014-07-18 00:33:43 +0200

Fogest gravatar image

I found that copying out the column to a text editor, and then simply pasting the data back in removed the formula's. This seems like a big work around but it will work for now.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-07-18 00:31:55 +0200

Seen: 2,403 times

Last updated: Jul 18 '14