[Solved] Separate Excel data in Cells using Comma to import
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!
Â
Latest Post: Cannot remember my Wifi Password Our newest member: rfds garew Recent Posts Unread Posts Tags
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed