Sign in

Microsoft.com

Microsoft

Remove From My Forums

wondering if there is a way to remove text from one cell that is already in the neighboring cell

Question
0

Sign in to vote

i have a list of 1000+ items and i was wondering if there was a way to remove certain items from a cell while leaving others?

for instance: Columns A & B below

A       B

xx      xxXX

x        xXXX

xxx    xxxX

I need to remove the lower case x's from column B because they are already in column A. Of course the x's stand for words and the info in column A & B were once identical except some info was removed from A and what is in A needs to be removed from B.  I would like to know if there is a way to do this other than manually going through each and every cell in the column.

Thanks

Wednesday, October 24, 2007 4:15 AM

Answers

0

Sign in to vote

JAGruber,

Thank you for visiting the Microsoft Genuine Advantage Forum. The purpose of this forum is the support of Windows Genuine Advantage (WGA) program. Your question is off topic as well as outside my area of knowledge. I suggest posting your question to one of the Office newsgroups here: http://www.microsoft.com/office/community/en-us/default.mspx?d=1 or http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.office.misc&lang=en&cr=US

If you should have other non-WGA questions please visit our other communities for helpful information here: http://www.microsoft.com/atwork/community.mspx . Thank you for visiting the forum.

Thank you,

Stephen Holm, MS

Thursday, January 10, 2008 10:31 PM

All replies

0

Sign in to vote

I forgot to mention that I am using Office 2007.

Wednesday, October 24, 2007 7:16 PM
0

Sign in to vote

JAGruber,

Thank you for visiting the Microsoft Genuine Advantage Forum. The purpose of this forum is the support of Windows Genuine Advantage (WGA) program. Your question is off topic as well as outside my area of knowledge. I suggest posting your question to one of the Office newsgroups here: http://www.microsoft.com/office/community/en-us/default.mspx?d=1 or http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.office.misc&lang=en&cr=US

If you should have other non-WGA questions please visit our other communities for helpful information here: http://www.microsoft.com/atwork/community.mspx . Thank you for visiting the forum.

Thank you,

Stephen Holm, MS

Thursday, January 10, 2008 10:31 PM