Hey guys, I was wondering if anyone knew how I could find 1 character and replace the entire cell. For example, it would find "<12", "<3", and "<32" based on "<" and then replaced that entire cell with "N/A". Thanks.
Hey guys, I was wondering if anyone knew how I could find 1 character and replace the entire cell. For example, it would find "<12", "<3", and "<32" based on "<" and then replaced that entire cell with "N/A". Thanks.
Last edited by VBA Noob; 11-07-2008 at 01:56 PM.
Try this
From the Excel Main Menu
<edit><replace>
Find what: *<*
Replace with: N/A
Click: [Replace All]
Does that help?
If "no"...<edit><undo>
that worked beautifully thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks