C
creativetechguy
I need Column E cell contents added into Column D cell contents (no
overwriting the data in each cell but mixing the data in the cells).
However, there is a clause. If the data in Column E is a room numbe
(these are my rooms numbers N408 N409 M100 ) then I want the cel
contents copied into Column F (not overwriting the contents of Column
just adding the room number text into whatever text is already in Colum
F).
All the cells have plain text. So not to worry with trying to cop
formulas.
Here is the skinny. I have three columns that need to be turned int
two columns. The first column (D) has a bunch of titles in it. Th
second column (E) has a mix of titles and room numbers. The thir
column (F) has all room numbers.
I need to take the second column (E) and distribute the contents int
the the first and third column without overwriting what already there.
Here is an example of what I have:
Column D Column E Column F
Happiness N408 M100
Joy Alfredo Books N409
Wonderful N409 N408
Glad Ballons
Work Day M100
Gonna stay N408 N409
Here is an example of what I need:
Column D Column E Column F
Happiness N408 M100
Joy Alfredo Books N409
Wonderful N409 N408
Glad Ballons M100
Work Day M100
Gonna stay N408 N409
I attached an excel document that might show up better than my tex
example above. I hope this explains what I am trying to do. If i
doesn't please let me know. Thanks
Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63804
overwriting the data in each cell but mixing the data in the cells).
However, there is a clause. If the data in Column E is a room numbe
(these are my rooms numbers N408 N409 M100 ) then I want the cel
contents copied into Column F (not overwriting the contents of Column
just adding the room number text into whatever text is already in Colum
F).
All the cells have plain text. So not to worry with trying to cop
formulas.
Here is the skinny. I have three columns that need to be turned int
two columns. The first column (D) has a bunch of titles in it. Th
second column (E) has a mix of titles and room numbers. The thir
column (F) has all room numbers.
I need to take the second column (E) and distribute the contents int
the the first and third column without overwriting what already there.
Here is an example of what I have:
Column D Column E Column F
Happiness N408 M100
Joy Alfredo Books N409
Wonderful N409 N408
Glad Ballons
Work Day M100
Gonna stay N408 N409
Here is an example of what I need:
Column D Column E Column F
Happiness N408 M100
Joy Alfredo Books N409
Wonderful N409 N408
Glad Ballons M100
Work Day M100
Gonna stay N408 N409
I attached an excel document that might show up better than my tex
example above. I hope this explains what I am trying to do. If i
doesn't please let me know. Thanks
Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63804