trying to compress 3 lines into one

[snoforlife]

i have 3 rows of words only 1 column in each row has a word and i want to make them all on the same line and get rid of the # vaule...the problem is that the "empty" spots have a formula in them so they are not technically blank

-- removed inline image ---

 

[hiker95]

snoforlife,

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

I would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), and provide us with a link to your workbook:

https://dropbox.com

 

[snoforlife]

Windows 8.1 excel 2013

 

[snoforlife]

the office im using is Microsoft office 365.. copied the data off of a website and the formatted it so that each different type of data ended up if a different column. (name, address, ect.) now i want to take that data and compress it all down to one line but there are 2 problems 1st all of the empty spots actually have a formula in them (ex: =a1), also one spot has #VALUE! and i need to get rid off all of them and the second is that one of the columns (name) might have more than one row filled up and i need both names (or to at least know that there are more names)

-- removed inline image ---

 

[hiker95]

snoforlife,

It looks like you attempted to display an IMG picture/file that did not work.

I have no experience with Microsoft Office 365.

In the future when asking for help, you should include in your title, or, at the beginning of your thread, that you are using Microsoft Office 365.

This way, you will get solutions from those helpers that have access to Microsoft Office 365.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.