Replacing text with number.

Y

Yo

I have attached a copy of part of the worksheet I am working with.
The original sheet has over 35000 rows.

In Column A is the ID#, I would like to replace "DID or DN" (text) in
column B with the ID# in Column A and have it make the change for
Column B when the ID# in a Changes.

Is this possible?

Thanks for any help.

Yolanda
 
F

Frank Kabel

Hi
not really sure but why not place the following formula in B1
=IF(A1<>"",A1,"")
and copy down for all rows
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two columns followed by single page-width column on same page 0
Excel does not accept text format! 0
Multiple seach and replace in excel 3
Replacing text with numbers 0
Formating bolded text exclusively. 0
how can i change a sequence of numbers using find replace 2
VLookup or Macro? 0
Need Help with a VBA subroutine 0

Top