Concatenate Feature Form

Upload your document
Select documents
Up to 100 MB for PDF and up to 25 MB for DOC, DOCX, RTF, PPT, PPTX, JPEG, PNG, or TXT
Note: Integration described on this webpage may temporarily not be available.
0
Forms filled
0
Forms signed
0
Forms sent
Function illustration
Upload your document to the PDF editor
Function illustration
Type anywhere or sign your form
Function illustration
Print, email, fax, or export
Function illustration
Try it right now! Edit pdf

Users trust to manage documents on pdfFiller platform

All-in-one PDF software
A single pill for all your PDF headaches. Edit, fill out, eSign, and share – on any device.

Concatenate Feature Form: easy document editing

The Portable Document Format or PDF is a popular file format used for business records because you can access them from any device. You can open it on any computer or smartphone running any OS — it will appear same for all of them.

The next point is security: PDF files are easy to encrypt, so they're safe for sharing data. That’s why it’s essential to choose a secure editing tool, especially when working online. PDF files can not only be password-protected, but analytics provided by an editing service allows document owners to identify those who’ve opened their documents and track potential security breaches.

pdfFiller is an online editor that allows you to create, modify, sign, and share PDF using just one browser tab. This tool is integrated with major CRM software, so users can sign and edit documents from Google Docs and Office 365. Forward it to others by fax, email or via sharing link, and get notified when someone opens and completes it.

Use editing features to type in text, annotate and highlight. Change a form’s page order. Once a document is completed, download it to your device or save it to the third-party integration cloud. Ask your recipient to complete the document and request an attachment. Add and edit visual content. Add fillable fields and send documents for signing.

Get your documents completed in four simple steps:

01
Get started by uploading your document.
02
Proceed to editing features by clicking the Tools tab. Now you can change the document's content or add a new one.
03
Add input fields if you need any; pdfFiller supports text, checkboxes, radio buttons, dropdown lists etc.
04
Finish editing by clicking Done and choose what you want to do next with this PDF: you can save it to your device, print or send via email, fax or sharing link.

What our customers say about pdfFiller

See for yourself by reading reviews on the most popular resources:
Verified Reviewer
2018-08-09
easiest way to fill forms! I like it and I recommend it to anyone who works with Forms that cannot be edited using another softwares. In my job we need to complete a LOT of forms (we are a law firm specialized in tax and corporate law so we need to complete a lot of forms that come in PDF format) and some of them doesn´t allow us to make any edit in the regular PDF program so PDFFiller is our salvation. It is super easy to use and it allows you to edit the entire document using only this software. You can add text or even delete parts that you don´t need. It is a software that doesn´t require any effort to understand because everything is as simple as upload the document, make the changes and save as pdf or print the document. I use it every day and I find it very complete for the things that I need. You are not able to use it in several computers, so if by mistake you open your session on another computer you may loose your work.
5
Terry W.
2018-04-19
Easy to use. I have been using this app for a long time and is really easy to learn how to use and reliable results. Pros. This does everything that Adobe apps should do. It is a great way to reduce paper use. UI looks a bit sophisticated, but it does what you need. Sometimes the support service takes a long time
5
Desktop Apps
Get a powerful PDF editor for your Mac or Windows PC
Install the desktop app to quickly edit PDFs, create fillable forms, and securely store your documents in the cloud.
Mobile Apps
Edit and manage PDFs from anywhere using your iOS or Android device
Install our mobile app and edit PDFs using an award-winning toolkit wherever you go.
Extension
Get a PDF editor in your Google Chrome browser
Install the pdfFiller extension for Google Chrome to fill out and edit PDFs straight from search results.

pdfFiller scores top ratings in multiple categories on G2

For pdfFiller’s FAQs

Below is a list of the most common customer questions. If you can’t find an answer to your question, please don’t hesitate to reach out to us.
Concatenate a row with comma/space by formula Highlight the B1:J1&”,” in the formula and press F9 key to replace cell references with cell contents. Note: In above formula, B1:J1 is the row you will concatenate, and “,” means you will separate each cell content by comma.
Cells into one under “What to merge”. Select the delimiter you want under “Separate values with”, it's a comma and a space in this example. Choose where you want to place the result, and most importantly. Uncheck the “Merge all areas in the selection” option.
Select a cell where you want to enter the formula. Type =CONCATENATE(in that cell or in the formula bar. Press and hold Ctrl and click on each cell you want to concatenate. Release the Ctrl button, type the closing parenthesis in the formula bar and press Enter.
Select the cell in which you want the combined data. Type an = (equal sign) to start the formula. Click on the first cell. Type the & operator. Type the text string for the character that you want between the words, for example:
Select a blank cell adjacent to the list's first data, for instance, the cell C1, and type this formula =CONCATENATE(TRANSPOSE(A1:A7)&”,”) (A1:A7 is the column you will convert to comma serrated list, “,” indicates the separator you want to separate the list). See screenshot below: 2.
Concatenate a row with comma/space by formula Highlight the B1:J1&”,” in the formula and press F9 key to replace cell references with cell contents. Note: In above formula, B1:J1 is the row you will concatenate, and “,” means you will separate each cell content by comma.
Select the cell where you need the result. Go to formula bar and enter =TRANSPOSE(A1:A5)& Select the entire formula and press F9 (this converts the formula into values). Remove the curly brackets from both ends.
0:57 2:43 Suggested clip Computer Help : How to Convert Excel to Comma Separated Text YouTubeStart of suggested client of suggested clip Computer Help : How to Convert Excel to Comma Separated Text
eSignature workflows made easy
Sign, send for signature, and track documents in real-time with signNow.