Test cell ISBLANK, if true concatenate two text cells
I have a big sheet of imported names and zip codes that I want to sort.
Some of the names have been split across two cells, one part beneath the other. The second part of the name has a blank zip code cell beside it.
I want to test for this blank cell and, if present, concatenate the two parts of the name and store it in a new cell.
I just can't get my head around the syntax - could anyone give me a pointer please?
Rollright Screenshot.JPG
in D2
=IF( B3 = "" , A2&A3 , A2)
IN E2 just put =B2
that should reproduce the table you have
However , can you produce a large sample in an spreadsheet and attach
so we can perhaps see any other issues
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Wayne, thank you for your swift response. Your code works great (I just added a space between the two parts of the name). However, I need to make it conditional so that if the cell in column B is blank, nothing is entered into the new column (I hope the screen shot explains this clearly) otherwise the last part of the name appears.
For information, the formula in column C allows me to tag blank cells in column B so that I can filter and eventually delete those rows.
Attachment 668304
Charles
does this work
=IF(B2="","",IF(B3="",A2&" "&A3,A2))
as mentioned perhaps a sample would help
That works perfectly - thank you!Originally Posted by etaf
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks