I have say the following
ARIEL WALL 25 X 35 = SNOW WHITE WM290A
result needed
MML 25 X 35 = ARIEL SNOW WHITE WM290A
Find attached file , do not want do this for 100 cards manually
Notes :
1 add word MML TO start
2 remove word WALL or FLOOR
2 Shift all words before size to after = sign
Maybe it will need formula helper added columns
Don't mind that too provided the end result is auto
Re: Stock card description renaming
Hi Makin..
Formula:
="MML "& SUBSTITUTE(MID(B1,FIND("X",B1)-3,LEN(B1)),"= ","= ARIEL ")
Check the attached file...
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Vikas that was hot and cool
Exactly what I needed
You will have to edit the formula to read First word instead of
writing ARIEL into the formula , not all tiles type are ARIEL
Vikas there is a small error
Its picking all cards as ARIEL
This one too
NYETRA 30 X 60 = CORNSILK MATT MB340A
Re: Stock card description renaming
Correction..
Formula:="MML "& SUBSTITUTE(MID(B1,FIND("X",B1)-3,LEN(B1)),"= ","= "&MID(B1,1,FIND(" ",B1,1)-1)&" ")
Check the attached file...
Vikas Thanks again
I know the thread is solved , asking added favor
If this is in c1
MML 25 X 35 = ARIEL SNOW WHITE WM290A
And I want , SHIFTING LAST WORD AFTER FIRST WORD AFTER THE =
MML 25 X 35 = ARIEL WM 290A SNOW WHITE
Re: Stock card description renaming
Done it..
But this time with a UDF...
Check the attached file...
Function StrManu1(ByRef Rang As Variant) As String x = Mid(Rang, InStr(1, Rang, "=") + 1, Len(Rang) - InStr(1, Rang, "=") + 1) Burst = Split(x, " ") Suffix = Burst(4) & " " & Burst(2) & " " & Burst(3) & " " & Burst(1) StrManu1 = Trim(Mid(Rang, 1, InStr(1, Rang, "=")) & " " & Suffix) End Function
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks