Pull cells in to one cell with line breaks while ignoring empty cells. I know this is probably 100% not the way to do it...
Luis Myers
If you could share how easy thatd be lovely
Dylan Adams
nvm figured it out
Hunter Ortiz
a solution share would be awesome if you did...
Owen Anderson
Pm sent
Henry Butler
No need to be mean...
Jackson Gonzalez
install gentoo
Nicholas Allen
totally not going to solve my issue but sure
Mason Ward
What's wrong with it how it is?
Eli Young
its throwing me errors in VBA.
Blake Foster
Do you have Excel 2019?
Ryder Thompson
Nope, working in 2013
Adam Ross
Pirate 2019 and use Textjoin.
Or else write your own vba function and use that.
Parker Hernandez
Ive never written vba functions before. Is there any way to simplify my formula or am I SOL?
Tyler Phillips
I know, but it's my little secret
*tee-hee*
Jordan Evans
it can be our secret, yeah?
Bentley White
Is char10 just a space?
Was that the whole point of this thread?
Nicholas Wood
This question is posted almost every day. Next time use the search function. Thread Locked.
Kevin Nelson
it is a line break
James Martinez
It's a new line and u just got trolled XD.
Parker Hall
Why can't you just use &? Why are you checking if a space is blank? And then setting the value to blank?
Andrew Campbell
The file i have may have no information present, and i do not want a line break to show, i just want it skipped.
Gavin Morales
Ok. I don't know how to help you if you don't even have any data. You are going to need either vba or 2019. I tried some autistic shit with double transposing the array.
Honestly you could have learned enough vba to write the function you need if you have been searching for hours.
Just Google how to write vba function to skip blank.
Caleb James
Use dataframes my nigger
Dominic Allen
try using python instead
Brody Cruz
Use an Excel lib with Python. Excel is powerful, but it isn’t a replacement for programming.