Small Excel Question Not Worth Its Own Thread

Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread

Lady Gaza: Nov 20, 2008

I've got a lot of data (genetic code) in Excel, where each letter is in a seperate cell. I need to copy the entire dataset into Word, but when I do so a tab is inserted between each letter. E.g.

In Excel the data are like this:

A|C|T|G|G|A|T|C|C|A

When I copy to Word they're like this:

A C T G G A T C C A

Whereas I need them like this:

ACTGGATCCA

Any ideas?

# ¿ Jul 21, 2011 13:04

Adbot: ADBOT LOVES YOU

# ¿ May 14, 2024 07:47

Lady Gaza: Nov 20, 2008

Yeah that's what I've been doing. Only problem is that it takes aaaaaages as genetic codes are quite long. Oh well! Thanks anyway

# ¿ Jul 21, 2011 14:26

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread