• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 534
  • Last Modified:

How do I shuffle up text in Excel?

Hi
I have text in two columns.
Some cells in column N are empty and I would like to shuffle up the text from column 0.
But if I have text in two column - I would like to keep it in two.
Can someone help?
Thanks.
Excel.png
0
juttaReimann
Asked:
juttaReimann
  • 3
  • 2
1 Solution
 
Brian PringleSystems Analyst II, SCM, ERPCommented:
I am assuming that the rows start at #1.

Select N2 and then hold the CTRL key and select O1.  Press the "Delete" key on the keyboard and it will ask if you want to shift cells up or shift left.  Select "Shift Cells Up".
0
 
juttaReimannAuthor Commented:
Sorry, I did not explain myself well.
I have over 2000 cells that need shifting, I was looking for a way of doing it automatically.
Thanks
0
 
wittysloganCommented:
something like this might help:

find 2 adjacent columns after you data
in column S:
=IF(AND(ISTEXT(N2)=FALSE,ISNUMBER(N2)=FALSE),O2,N2)

in column T:
=IF(AND(ISTEXT(N2)=FALSE,ISNUMBER(N2)=FALSE),"",O2)

then copy and paste values into the relevant columns.

At the moment if column o is blank you may be left with a zero is this a problem?

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
juttaReimannAuthor Commented:
Sorry to be a pain.
The ZERO is a problem, as I am going to export the data to a database.
Any more ideas?
0
 
wittysloganCommented:
try these:

S:
=IF(ISBLANK(N2)=TRUE,O2,N2)

T:
=IF(OR(ISBLANK(N2)=TRUE,ISBLANK(O2)=TRUE),"",O2)
0
 
juttaReimannAuthor Commented:
Thank you that works beautifully.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now