Hi guys,
Newbie here. I'm trying to figure out how to replace a set of cells that have numbers in them with text.
Basically I need a function to say, if there is a # in this cell, replace it with "Yes", if not, leave it alone.
If you guys could help out I would appreciate it immensely!
Thanks
Let's say your data is in column A starting in A2
In F2 (or any other empty column)
=IF(ISNUMBER(A2), "Yes", A2)
copied down
Then copy and Paste Special>Values on top of column A to replace the original data with the new data if that's what you want.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you! That worked perfectly!
You saved me a ton of time going through each one and replacing them all manually.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks