FILE ATTACHED.
A B C
1 HQ003415P0160 P0008 HQ003415P0160P0008
----------------------------------
I need a formula that checks if B1 has a five digit text string entry and if it does, it joins the text from column A and B in column C. I tried =if(B1="?????", concatenate(A1, B1)) but that didn't work.
Thanks in advance for your help!
Jason
Last edited by jasonb9; 11-14-2018 at 08:57 AM.
Try this:
=IF(LEN(B1)=5,CONCATENATE(A1,B1))
Please attach an Excel sheet with REPRESENTATIVE data in it. You said a five digit text string entry.... but it looks like 13-14 characters to me...
So what is the range of stuff you have to work with and what are your expected outcomes. So, a sheet please - not a picture of one.
Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Ok, thanks. I'll repost with the sheet attached. I'm new so I appreciate the help.
I would recommend adding the example sheet here (there is a go advanced option for replying too), as a repost will likely be closed by a moderator (as this is against the rules).
I uploaded the file.
Please see post # 2
PROBLEM SOLVED!! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks