Excel copy data

F

Fred Smith

It depends what you mean by "appear next to", but let's assume your data is
in column A, and you want the customer name in column B. In B1, enter =a1.
In B2, use:

=if(istext(a2),a2,b1)

and copy down.

Regards,
Fred

in message news:[email protected]...
 
A

Ashish Mathur

Hi,

Say your data is in range C3:C10. In D3, enter the following formula and
then copy down till D10

=IF(ISNUMBER(C3),LOOKUP(REPT("z",99),$C$3:C3),"")

There copy D3:D10 and paste them as values. After this, you may delete the
text entries in C3:C10.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

in message news:[email protected]...
 

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

Top