JuicyMusic
Board Regular
- Joined
- Jun 13, 2020
- Messages
- 210
- Office Version
- 365
- Platform
- Windows
Hi Guru's, I have a formula that I found on another post from FLUFF here on MrExcel. I would like help adjusting it. I DOWNLOADED XL2BB SO PLEASE TELL ME IF IT IS WORKING.
Here is the formula I am needing adjustment to:
I would like the characters to remain in the 2nd column that is deliminated. If there is only an "*" in the original data, then column 2 should be blank.
Here is the original data I am working with - the next 2 columns are showing the results I would like to see:
Thank you everyone,
Juicy
Here is the formula I am needing adjustment to:
Excel Formula:
=TRIM(MID(SUBSTITUTE("*"&$I8,"*",REPT(" ",100)),COLUMNS($J8:J8)*100,100))
I would like the characters to remain in the 2nd column that is deliminated. If there is only an "*" in the original data, then column 2 should be blank.
Here is the original data I am working with - the next 2 columns are showing the results I would like to see:
DESIRED RESULTS - col 1 | DESIRED RESULTS - col 2 | ||
ORIGINAL DATA TO TEXT DELIMINATE | CITY NAMES (in new 1st column) | CITY NOTE (in new 2nd column) | |
Adelanto* | Adelanto | ||
Alberhill (Lake Elsinore*) | Alberhill | (Lake Elsinore*) | |
Alta Loma (Rancho Cucamonga*) | Alta Loma | (Rancho Cucamonga*) | |
Alviso (San Jose*) | Alviso | (San Jose*) | |
Amargosa (Death Valley) | Amargosa | (Death Valley) | |
Bay Point (formally West Pittsburg) | Bay Point | (formally West Pittsburg) | |
Beverly Hills* | Beverly Hills | ||
Big Bear Lake* | Big Bear Lake | ||
Coto De Caza | Coto De Caza | ||
Crest Park | Crest Park | ||
Daggett | Daggett | ||
Davis* (U.C. Davis campus rate is 7.25%) | Davis | (U.C. Davis campus rate is 7.25%) | |
Del Sur | Del Sur | ||
Dos Rios | Dos Rios | ||
Santa Barbara* (U.C. Santa Barbara campus rate is 7.75%) | Santa Barbara | (U.C. Santa Barbara campus rate is 7.75%) |
Thank you everyone,
Juicy