# Formula to move contents from one cell to the next

1. ## Formula to move contents from one cell to the next

I'm working on a speadsheet that has thousands of line items with lots of great information, but not in the fields I need them to be in. Is there a formula to move for example cell contents A26 to B25 and D26 to F27? Also I have contents in one cell that I need to break apart is there a formula for that too? I searced the help and the net an came up with nothing. Maybe I'm not wording it correctly, but I'd appreciate the help.

2. ## Re: Formula to move contents from one cell to the next

What I've done in cases like these is, in cell in B25, just put '=A26'

A26 to B25 and D26 to F27

If that's the case, you can just fill in all the cells, then copy the values into a new sheet, then paste them back in the same spot. You can then get rid of your values in row 26.

If that's confusing let me know

3. ## Re: Formula to move contents from one cell to the next

If I do it that way then when I get rid of A26 since it's pulling from this cell B25 goes away too. I'm wanting to move the contents from one cell to another cell.

In A25 I have a name and in A26 there is a phone number and I'm wanting that phone number to be in the cell next (B25) to the name and not underneath the name if it were just a few no big deal i'd move them one by one but I have thousands to move. Maybe there is not such an animal in formulas.

4. ## Re: Formula to move contents from one cell to the next

When you say it goes away, what do you mean? Are you saying that when you delete the contents of cell A26, that B25 also is empty? This is because B25 is referencing the contents of A26, which is why if you copy B25, etc, and then paste the 'Values' (paste special, otherwise it'll paste the forumula in there) and then paste it back to where you need it, you should still retain the information in there.

If you're still having issues, perhaps you could upload a dummy sample and I can take a look at it, since I'm confused otherwise.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1