help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a range of six cells in a row on my spread sheet. Five cells are empty
and one contains data. I would like to find the single cell that contains
text and copy that text into a cell at the end of the row
 
You can do that with a formul if you wish. In the cell where you would like
the value add the formula (assuming row 1)...

=A1 & B1 & C1 & D1 & E1 & F1

Which will concatenate all of the cell values together. Since 5 of the six
are blank it will be just the text from the one populated cell.
 
You got more replies at your other posts.

I have a range of six cells in a row on my spread sheet. Five cells are empty
and one contains data. I would like to find the single cell that contains
text and copy that text into a cell at the end of the row
Click to expand...
 
You must log in or register to reply here.

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

VBA set thick borders around non empty cells in range 0
Dynamic Offset from an Application.Goto cell = Date or Time 10
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Clean this select case code up a bit. 2
5 months prior to date macro help please 13
once more - - - 2
Excel 2013 Merge Data 2
lost . . . 3

Back
Top