Seemingly Simple Excel Assistance

quote:

---

So I've got a list of about 150 or so cells in one column... I need to get 5-digit numbers out and separated by a comma. (maybe in a text/word doc?)

---

So it is a list of numbers, and you need to pull 5 digits out of the list of numbers?

So turn a 12345678 into 45,678?

You can use the char left or right for how many you want left or right, and then you can change number formatting for all the cells to separate those numbers by commas. You can use that same setting to pick just 5 digit numbers too...depends on what youre doing.

Yeah depending on where the 5 digits are within the list, you use either the LEFT MID or RIGHT functions.

The ask is confusing.

Kind of vaugue, but if I understand correctly I would.

Highlight the row and click the button to push everything left.
Save file as a .prn
Open that file back up with excel and it will prompt you to set the rows in a text to column type deal.
Set your columns to capture the digits you need and the remaining digits in an additional column.
format your new column to numbers and add the comma you desire.
Re-save as an excel file.

If cell A1 has 56789 in it and you want it to say "5,6,7,8,9".

Select cell right next to the first one. In cell B1 type in =Mid(A1,1,1)&","&Mid(A1,2,1)... that's the first two digits, continue that sequence in the same cell for the remaining three characters. Then just drag that formula down.

Apologies for a vague ask...

For simplicity's sake, lets call them 'zip codes' (5-digits)

There's on 'zip' in each cell of a column and I need to add them to a boolean search separated by commas...

Basically:
______
|12345|
______
|67890|
______
|09876|

to

12345, 67890, 09876, etc

Assuming your 150 values are in column A

In the column (col B) to the right enter this: = A1 + ", "
Copy that and paste all the way down column B

This formula will add a second column with commas following the zips in column B

Copy column B
Paste special - select "transpose" and paste into column C

This creates a string of 150 columns in one row with commas following the values.

Now copy that row starting in column C to the last value.

Paste in notepad.

You're done

Assuming your data is in column 1 this should work
=IF(B1="",A1&","&A2,B1&","&A2)