Forum

Separate Excel data...
 
Share:
Notifications
Clear all

[Solved] Separate Excel data in Cells using Comma to import


forcego
(@forcego)
Active Member
Joined: 3 years ago
Posts: 5
Topic starter  

Hi there,

I need a small help in Excel. I have a list of items in Excel in rows. But I need to arrange them using comma and import. The issue is I have around hundreds of items.

TIA

 


prime liked
Quote
Topic Tags
prime
(@user)
New Member
Joined: 3 years ago
Posts: 4
 

Hello Forcego,

You can use the TEXTJOIN(). The Excel TEXTJOIN function concatenates (joins) values with a given delimiter. Unlike the CONCAT function, TEXTJOIN allows you to supply a range of cells.

Syntax

=TEXTJOIN (delimiter, ignore_empty, text1, [text2], ...)

Arguments

  • delimiter - Separator between each text.
  • ignore_empty - Whether to ignore empty cells or not.
  • text1 - First text value or range.
  • text2 - [optional] Second text value or range.

 

Example

Suppose your data is in the below range.

A1:A18

 

Then the function would be :

=TEXTJOIN(",",TRUE,A3:A18)

 

Hope this clarifies you.

Have a nice day!

 


forcego liked
ReplyQuote
Share:
Newsletter Signup

Subscribe to our newsletter below and never miss the latest product or an exclusive offer.