asked on Help for the formula
HI Rob,
Need small help on the this formula in (columns B), which is for read space but i have done up to 2 spaces only but when i m trying 3rd (Row A)
i m getting error or not reading.
formula is for trim & uppercase
Thanks,
Need small help on the this formula in (columns B), which is for read space but i have done up to 2 spaces only but when i m trying 3rd (Row A)
i m getting error or not reading.
formula is for trim & uppercase
Thanks,
Microsoft ApplicationsMicrosoft OfficeSpreadsheetsMicrosoft Excel
Last Comment
M Zahid
Hi Zahid,
Use below in B2 and drag down:
Use below in B2 and drag down:
=TRIM(CLEAN(SUBSTITUTE(UPPER(A2),CHAR(160)," ")))
ASKER
this will read the whole thing from column A which may not required that's i was using to read it up to first spaces
What are you trying to achieve? please post a sample with desired output with some more examples.
ASKER
sir have u seen my attached file? i have mentioned in that file what i m looking for, plz advice if that is not clear?
ASKER
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks Shums, that is what i want to achieve :)
fromula-AML.xlsb