I need a column that has:
, Tan, Black
, White
to show:
Tan, Black
White
quick fix please?
I need a column that has:
, Tan, Black
, White
to show:
Tan, Black
White
quick fix please?
If your data is in column A, then in B1 enter:
=IF(LEFT(A1,2)=", ",MID(A1,3,9999),A1) and copy down.
Gary's Student
Thank you so much this will work!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks